Re: in-date news items - Mailing list pgsql-sql

From Ian Barwick
Subject Re: in-date news items
Date
Msg-id 02031214251401.06708@redgrave
Whole thread Raw
In response to in-date news items  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
On Tuesday 12 March 2002 13:17, Gary Stainburn wrote:
> Hi all,
>
> I'm trying to use a select to get the latest item of news, provided that
> it's within the last X days.  What do I need to add to the where clause for
> the select statement below:
>
> select ndate, nauthor, nheading
>     from news
>     order by ndate desc
>     limit 1
> *** where ndate within the last 3 months ******
> ;

something like:
where ndate > current_timestamp - interval '3 months'  

more on the subject here:

http://techdocs.postgresql.org/techdocs/faqdatesintervals.php

Ian Barwick


pgsql-sql by date:

Previous
From: Hubert Palme
Date:
Subject: Re: Line Numbering in SELRCT Output
Next
From: "Dag Arne Matre"
Date:
Subject: Re: where not exists