Date Comparison Help - Mailing list pgsql-general

From Brian C. Doyle
Subject Date Comparison Help
Date
Msg-id 6.0.3.0.2.20040408152839.01cb6c00@pop3.umpa-us.com
Whole thread Raw
Responses Re: Date Comparison Help
Re: Date Comparison Help
List pgsql-general
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?



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: Alexander Cohen
Date:
Subject: pg_ctl problem
Next
From: Bruno Wolff III
Date:
Subject: Re: To_char statement problems