Thread: 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

"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/

> 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

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