Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A0E604760F0 for ; Fri, 8 Nov 2002 13:19:01 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id 23B68476021 for ; Fri, 8 Nov 2002 13:19:01 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18ADje-0006pR-00 for ; Fri, 08 Nov 2002 11:20:02 -0700 Date: Fri, 8 Nov 2002 11:20:02 -0700 From: Roberto Mello To: pgsql-sql@postgresql.org Subject: Time difference without intervals Message-ID: <20021108182002.GC25961@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/142 X-Sequence-Number: 10284 I saw this question on another PG mailing list, and I don't know how to answer. I've tried casting the interval to a timestamp, but that doesn't seem to be supported in 7.2. Does anyone have an answer? Is there any way to make a timestamp difference operation not return an interval? I'd like to get hours, minutes and seconds only, not the "1 day" or whatnot. lbn-dev=# select now() - '2002-11-07 7:42'::timestamp; ?column? ----------------------- 1 day 02:01:57.987838 (1 row) Thanks, -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + TAGLINE NO ESPELHO ¤ OHLEPSE ON ENILGAT