Technical Article

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)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating