Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA19326 for ; Tue, 17 Aug 1999 09:27:24 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 26D5A4B5D1; Tue, 17 Aug 1999 16:27:22 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA6305; Tue, 17 Aug 1999 16:30:59 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <551413BBBB03D111BF880060B01AACCE139F34@home.priority.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 17 Aug 1999 16:28:44 +0300 To: "Pham, Thinh" , "'pgsql-sql@postgreSQL.org'" From: Herouth Maoz Subject: RE: [SQL] datediff function At 16:18 +0300 on 17/08/1999, Pham, Thinh wrote: > What happen if i just want to compare using minute only or hour only instead > of day? Is there a function to do that or is postgres only work in day? No problem, just write 'now'::datetime - '6 hours'::timespan. Or some such. Please read about the datetime and timespan types in the user guide. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma