Friday, 15 January 2010

SQL Server get Date part from DateTime

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

No comments:

Post a Comment