12 May

How to work out dates sql server 2005 / transact SQL

Category: SQL Server, SQL Server 2005

http://msdn.microsoft.com/en-us/library/ms186724.aspx

Its really easy to do - best to do all of this on the database - that’s what it is for!

This finds stuff that is from 6 months ago until today:

WHERE yourDate BETWEEN DATEADD(MONTH, -6, CURRENT_TIMESTAMP) AND CURRENT_TIMESTAMP

Posted Monday, May 12th, 2008 at 8:28 pm
Filed Under Category: SQL Server, SQL Server 2005
Responses are currently closed, but you can trackback from your own site.

0

Comments are closed.