Today

declare @today datetime
set @today = CAST(convert(varchar, GETDATE(), 101) as datetime)

SELECT @today AS Today

-- Result (year-month-day):
/*
Today
-----------------------
2009-01-08 00:00:00.000
*/