Postgres Pro
Downloads
Home   >   mailing lists

Re: Date Comparison Help - Mailing list pgsql-general

From Mike Nolan
Subject Re: Date Comparison Help
Date
Msg-id 200404082024.i38KO0QU014350@gw.tssi.com
Whole thread Raw
In response to Date Comparison Help  ("Brian C. Doyle" <bdoyle@umpa-us.com>)
Responses Re: Date Comparison Help
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Clodoaldo Pinto Neto
Date:
Subject: pgsql yum update for Fedora system?
Next
From: Clodoaldo Pinto Neto
Date:
Subject: Postgresql yum update for Fedora Core 1 system?