Revisions to Hidden Features of SQL Server

added 89 characters in body

edited Feb 17, 2009 at 11:28

Return Date Only

Select Cast(Floor(Cast(Getdate() As Float))As Datetime)

or

Select DateAdd(Day, 0, DateDiff(Day, 0, Getdate()))

Return Date Only

Select Cast(Floor(Cast(Getdate() As Float))As Datetime)

Return Date Only

Select Cast(Floor(Cast(Getdate() As Float))As Datetime)

or

Select DateAdd(Day, 0, DateDiff(Day, 0, Getdate()))

Updated with shorter version.

edited Dec 15, 2008 at 16:03

Return Date Only

Select Convert([smalldatetime],floorCast(ConvertFloor([float],getdateCast(),Getdate(0) As Float)),(0)As Datetime)

Return Date Only

Select Convert([smalldatetime],floor(Convert([float],getdate(),(0))),(0))

Return Date Only

Select Cast(Floor(Cast(Getdate() As Float))As Datetime)

Post Made Community Wiki by CommunityBot

occurred Sep 29, 2008 at 17:00

answered Sep 23, 2008 at 15:54

Return Date Only

Select Convert([smalldatetime],floor(Convert([float],getdate(),(0))),(0))

Return to Answer