T-SQL Code to get last 6 months

midway11 · October 12th, 2006, 06:34 PM

Hi there,

I am trying to get the last 6 months of data from a table in SQL Server 2005. Does any body out there know how to write this code to accomplish this?

Thanks in advance,

Midway

Jeff Mason · October 15th, 2006, 08:59 AM

The DATEADD function allows you to compute a date that is 6 months ago:

Code:

    DATEADD(m, -6, current_timestamp)

use this to compare your date column:

Code:

    SELECT *
      FROM yourtable
     WHERE yourdatecolumn > DATEADD(m, -6, current_timestamp);

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com