Received: from lubitsch.akademie.de (ns.akademie.de [62.165.4.3]) by postgresql.org (Postfix) with ESMTP id C8F20474E44 for ; Tue, 12 Mar 2002 08:25:27 -0500 (EST) Received: from [62.165.4.160] (helo=redgrave) by lubitsch.akademie.de with smtp (Exim 3.33 #2) id 16kmHI-0001Qm-00; Tue, 12 Mar 2002 14:25:20 +0100 From: Ian Barwick Organization: akademie.de Date: Tue, 12 Mar 2002 14:25:14 +0100 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: Gary Stainburn , "pgsql-sql" References: In-Reply-To: Subject: Re: in-date news items MIME-Version: 1.0 Message-Id: <02031214251401.06708@redgrave> Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/165 X-Sequence-Number: 7045 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