Viewing post 1 (of 1 total)
In SQL-Server 2008: usenew datatype date
DECLARE @DateOnly DATETIME
SET @DateOnly = CAST(CAST(GetDate() AS Date) AS DATETIME)
SELECT @dateonly
July 30, 2009 at 12:10 am
#1032188