Saturday, May 11, 2019

How to Remove/Truncate Time Part from DateTime stamp

select DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)

or

select CONVERT(DATE, getdate(), 101)

or

SELECT CONVERT(DATE,GETDATE())

or

SELECT CAST(FLOOR(CAST(getdate() AS FLOAT)) AS DATETIME)

No comments:

Post a Comment

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...