Re: Date Comparison Help

From: "Brian C(dot) Doyle" <bdoyle(at)umpa-us(dot)com>
To: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Date Comparison Help
Date: 2004-04-08 20:29:13
Message-ID: 6.0.3.0.2.20040408162847.02e2eec0@pop3.umpa-us.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>http://www.umpa-us.com
1-800-555-9665 ext 212

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randall Skelton 2004-04-08 20:41:38 Re: extract epoch and index scanning
Previous Message Mike Nolan 2004-04-08 20:23:59 Re: Date Comparison Help