Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B33424762EB for ; Mon, 11 Nov 2002 00:16:41 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id 4A5634762E2 for ; Mon, 11 Nov 2002 00:16:41 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18B6xF-0006Gr-00; Sun, 10 Nov 2002 22:17:45 -0700 Date: Sun, 10 Nov 2002 22:17:45 -0700 From: Roberto Mello To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: Time difference without intervals Message-ID: <20021111051745.GG23100@cc.usu.edu> References: <20021108182002.GC25961@cc.usu.edu> <27705.1036789865@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <27705.1036789865@sss.pgh.pa.us> 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/158 X-Sequence-Number: 10300 On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote: > Roberto Mello writes: > > 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. > > I think your complaint is not that you get an interval, but that you > want it displayed differently. See to_char() ... It was not a complaint in any way. I apologize if I came across like that. It was an honest question. Thanks for the replies. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + "Apple" (c) Copyright 1767, Sir Isaac Newton.