Thursday 7 February 2013

SQL : Get Date Only

SQL
DATEADD(dd,0, DATEDIFF(dd, 0, GETDATE()))

SQL 2008
CAST(GETDATE() AS DATE)

No comments:

Post a Comment