Today with no time portion

,

How to get current day with the timeportion = 00:00:00.000.

Works regardless of locale.

SELECT DATEADD(dd,CAST(DATEDIFF(DAY,'17530101',CURRENT_TIMESTAMP) AS INT),'17530101') AS TodayWithNoTime

Rate

5 (1)

Share

Share

Rate

5 (1)