Re: Date Comparison Help - Mailing list pgsql-general

From Brian C. Doyle
Subject Re: Date Comparison Help
Date
Msg-id 6.0.3.0.2.20040408162847.02e2eec0@pop3.umpa-us.com
Whole thread Raw
In response to Re: Date Comparison Help  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
Perfect and thank you so much for the swift response;

At 04:23 PM 4/8/2004, Mike Nolan wrote:
> I need a query to get data that is 6 months older than "today" or when that
> query is run.

WHERE table.date < current_date-interval'6 months'
--
Mike Nolan



UMPA Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
http://www.umpa-us.com
1-800-555-9665 ext 212

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Why would query return PGRES_NONFATAL_ERROR?
Next
From: "Michael Fork"
Date:
Subject: Re: Select/Group by/Order by question