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(at)apartia(dot)org - http://www.apartia.org
"Perl Guy and Executive Glue Sniffer"
(stolen from Aaron Sherman's .sig)