Re: Date Comparison Help

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: bdoyle(at)umpa-us(dot)com (Brian C(dot) Doyle)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Date Comparison Help
Date: 2004-04-08 20:23:59
Message-ID: 200404082024.i38KO0QU014350@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian C. Doyle 2004-04-08 20:29:13 Re: Date Comparison Help
Previous Message Clodoaldo Pinto Neto 2004-04-08 20:21:13 Postgresql yum update for Fedora Core 1 system?