missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp) - Mailing list pgsql-sql

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)