Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54]) by hub.org (8.10.1/8.10.1) with ESMTP id e5N1pL184963 for ; Thu, 22 Jun 2000 21:51:21 -0400 (EDT) Received: from austin.rr.com ([24.93.36.87]) by mail.austin.rr.com with Microsoft SMTPSVC(5.5.1877.357.35); Thu, 22 Jun 2000 20:52:00 -0500 Message-ID: <3952C394.67050AC5@austin.rr.com> Date: Thu, 22 Jun 2000 20:55:32 -0500 From: Ed Loehr X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686) X-Accept-Language: en MIME-Version: 1.0 To: Jeff MacDonald CC: pgsql-sql@postgresql.org Subject: Re: timespan casting References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/197 Jeff MacDonald wrote: > bignose=> select start,stop, stop-start as start_stop from foo; > start | stop | start_stop > ------------------------+------------------------+------------ > 2000-06-22 20:37:12-03 | 2000-06-22 20:37:12-03 | 00:000 > > now my question.. first of all is the first start_stop result a little > off ? (talking about the 3 0's..) What's off about it?? Your start and stop appear identical. > second is there a way i can do a select so it says something more human > usable ie : 100 days 22 hours 32 minutes.. Try to_char(). http://www.postgresql.org/docs/postgres/x2976.htm Regards, Ed Loehr