X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C7F2C476348 for ; Thu, 8 May 2003 03:48:10 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 01629475EC9 for ; Thu, 8 May 2003 03:48:09 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.nordlb.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h487m7bg023192 for ; Thu, 8 May 2003 10:48:08 +0300 Received: from share.nordlb.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Thu, 08 May 2003 10:48:06 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h487m6w02120 for ; Thu, 8 May 2003 10:48:06 +0300 Received: (qmail 16898 invoked by uid 100); 8 May 2003 07:50:14 -0000 Date: Thu, 8 May 2003 10:50:14 +0300 From: "Victor Yegorov" To: "David Loh" Cc: Subject: Re: A minute in timestamp Message-ID: <20030508075014.GF1764@nordlb.lv> Mail-Followup-To: "David Loh" , References: <003501c3152c$b3872a30$f92c2c0a@david> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="mojUlQ0s9EVzWg2t" Content-Disposition: inline In-Reply-To: <003501c3152c$b3872a30$f92c2c0a@david> User-Agent: Mutt/1.4.1i X-Spam-Status: No, hits=-28.1 required=5.0 tests=BAYES_10,IN_REP_TO,PGP_SIGNATURE_2,REFERENCES, USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/160 X-Sequence-Number: 13325 --mojUlQ0s9EVzWg2t Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * David Loh [08.05.2003 10:03]: > Hi all. > 'select * from myTable where date_part('minute',Update_Time > - now()) = =3D 1;' Does it helps, if you'll try this: select * from myTable where date_part('second', now() - Update_Time) betwee= n 55 and 65; --=20 Victor Yegorov IT Programmer, NORD/LB Latvija JSC Fax (+371) 7323449, Phone (+371) 7077142, Mobile (+371) 9131883 --mojUlQ0s9EVzWg2t Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE+ugw12RKGLEykUDYRAiqFAJ4mRwdlnQymHxMeBNbbUn3SVXaU4gCgraNV dhrCjCn67TZJHzAIPvhXRTU= =Q4DW -----END PGP SIGNATURE----- --mojUlQ0s9EVzWg2t--