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