Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA11870 for ; Wed, 17 Jun 1998 09:21:38 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id QAA21393; Wed, 17 Jun 1998 16:17:05 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: References: <199806171233.IAA01017@bentley.eso.mc.xerox.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Wed, 17 Jun 1998 16:17:15 +0300 To: patrice@idf.net, Kevin Colagio From: Herouth Maoz Subject: Re: [SQL] Time related question... Cc: pgsql-sql@postgreSQL.org At 15:45 +0300 on 17/6/98, Patrice H=E9d=E9 wrote: > with datetime, it could be then : > > select * from servicecall whre (dateclosed - dateentered) < '3 days'; > > However, if you really need abstime, I don't know the answer. Actually, all that needs be done is to cast the abstime as datetime. Such as= : SELECT * =46ROM servicecall WHERE ( datetime( dateclosed ) - datetime( dateentered ) ) < '3 days'; Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma