Re: in-date news items

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