Sunday, October 28, 2018

SQL Server - Subtract/Add hours from date


SELECT DATEADD(HOUR,-1,DateTimesColumn)

or

select dateadd(HOUR, -8/2 ,'07/01/2018')
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Recently Executed queries

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