Received: from styx.apartia.int (postfix@dyn-1-1-214.Vin.dialup.oleane.fr [195.25.4.214]) by hub.org (8.10.1/8.10.1) with ESMTP id e8NGUis85614 for ; Sat, 23 Sep 2000 12:30:44 -0400 (EDT) Received: by styx.apartia.int (Postfix, from userid 1000) id 46FBD5AF4; Sat, 23 Sep 2000 17:45:20 +0200 (CEST) Date: Sat, 23 Sep 2000 17:45:20 +0200 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp) Message-ID: <20000923174520.A10680@styx> Reply-To: ldm@apartia.ch Mail-Followup-To: pgsql-sql@postgresql.org References: <20000921181036.3514.qmail@web805.mail.yahoo.com> <5.0.0.19.2.20000921145244.02438d00@pop> <39CA6EA1.5610BD7@ipinc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <39CA6EA1.5610BD7@ipinc.com>; from jliang@ipinc.com on Thu, Sep 21, 2000 at 01:25:05PM -0700 X-Archive-Number: 200009/191 On Thu, Sep 21, 2000 at 01:25:05PM -0700, Jie Liang wrote: > Hi, there, > > urldb=# create table foo(sec int4); > CREATE > urldb=# insert into foo values(54321); > INSERT 382942319 1 > urldb=# select interval(reltime (sec||'secs')) from foo; > interval > ---------- > 15:05:21 > (1 row) By the way, is it normal that the "day" word doesn't appear in the interval? auction=# select interval(now()::abstime::int4); interval ---------------------------- 30 years 9 mons 3 15:42:09 (1 row) -- Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org "Perl Guy and Executive Glue Sniffer" (stolen from Aaron Sherman's .sig)