Re: in-date news items

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: in-date news items
Date: 2002-03-12 17:50:07
Message-ID: Pine.LNX.4.30.0203121248130.760-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gary Stainburn writes:

> select ndate, nauthor, nheading
> from news
> order by ndate desc
> limit 1
> *** where ndate within the last 3 months ******

ndate >= current_date - interval '3 months' and ndate <= current_date

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Culley Harrelson 2002-03-12 17:55:53 Support for "nested sets" and PHP (Re: Recursive select)
Previous Message Andrew G. Hammond 2002-03-12 17:46:22 Re: SELECT FOR UPDATE