The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,860 other followers

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: