Date Comparison Help

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

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&gt;http://www.umpa-us.com
1-800-555-9665 ext 212

"Brian C. Doyle" <bdoyle@umpa-us.com> wrote:

Hello all,

I am rather confident that this has been answered in the past but searching
for it has been a pain so I am asking for some assistance.

I need a query to get data that is 6 months older than "today" or when that
query is run.

So the where clause is something like

WHERE table.date >= now() - 6 months

I know that will not work so how should I do this?

WHERE age(table.date) > '6 months'

--
Jim Seymour | Spammers sue anti-spammers:
jseymour@LinxNet.com | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
| http://www.spamcon.org/legalfund/