SQL Server: some date calculation logic
Posted by jpluimers on 2010/10/28
I always forget the syntax, because different DBMS systems use different ways of doing this.
This is the SQL Server way of doing some date calculations:
SELECT GETDATE()
, GETDATE() - 14
, GETDATE() + 14
, DATEDIFF(day, GETDATE(), GETDATE() - 14)
, DATEDIFF(day, GETDATE(), GETDATE() + 14)
, DATEADD(day, - 14, GETDATE())
, DATEADD(day, + 14, GETDATE())
Used functions:
Reference: Database Journal article.
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a Reply