Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.2/8.9.1) with ESMTP id HAA29134 for ; Tue, 9 Mar 1999 07:55:19 -0500 (EST) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id NAA21413; Tue, 9 Mar 1999 13:54:22 +0100 (CET) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <36E519FE.935BE019@partitur.se> Date: Tue, 09 Mar 1999 13:54:22 +0100 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.51 [en] (X11; I; FreeBSD 3.1-STABLE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: Remigiusz Sokolowski CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] time comparing References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Remigiusz Sokolowski wrote: > > hi! > I need to compare two values of time. > One of them is just value of field - I want to compare it to value of > now() less 1 hour - shortly I want to select all records which are older > then 1 hour - how to do that? Ah! This reminds me! I've been wondering about a similar problem. How do I exchange that 1 hour with one week or one month? Probably the same way as with one hour (if there is any easy way)... Regards, Patrik Kudo