Received: from rage.hub.org (root@nat204.112.mpoweredpc.net [142.177.204.112]) by hub.org (8.10.1/8.10.1) with ESMTP id e5MNkZ129898 for ; Thu, 22 Jun 2000 19:46:35 -0400 (EDT) Received: from localhost (bignose@localhost) by rage.hub.org (8.9.3/8.9.3) with ESMTP id UAA55674 for ; Thu, 22 Jun 2000 20:46:30 -0300 (ADT) (envelope-from jeff@pgsql.com) X-Authentication-Warning: rage.hub.org: bignose owned process doing -bs Date: Thu, 22 Jun 2000 20:46:30 -0300 (ADT) From: Jeff MacDonald X-Sender: bignose@rage.hub.org Reply-To: Jeff MacDonald To: pgsql-sql@postgresql.org Subject: timespan casting Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200006/195 hi, thought this up while playing with time spans.. here is my table and data.. bignose=> \d foo Table "foo" Attribute | Type | Modifier -----------+-----------+---------- start | timestamp | stop | timestamp | 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 2000-06-22 20:40:40-03 | 2000-06-23 20:40:40-03 | 1 00:00 2000-06-22 20:40:53-03 | 2000-09-30 20:40:53-03 | 100 00:00 2000-06-22 20:41:08-03 | 2000-06-23 02:41:08-03 | 06:00 2000-06-22 20:41:30-03 | 2010-11-22 19:41:30-04 | 3805 00:00 (5 rows) now my question.. first of all is the first start_stop result a little off ? (talking about the 3 0's..) second is there a way i can do a select so it says something more human usable ie : 100 days 22 hours 32 minutes.. jeff