On Sep 14, 2010, at 7:57 , Howard Cole wrote:
> create table test (test_id serial primary key, time_in_minutes int);
> insert into test values (1440);
>
> Now how do I extract that as 24:00:00::interval in a query?
test=# SELECT 1440 * INTERVAL '1 minute';
?column?
----------
24:00:00
(1 row)
Michael Glaesemann
grzm seespotcode net