Hi everyone,I have a table with a duration field, stored as an Integer. How can I retrieve this from the table as an Interval type?
E.g. 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? Thanks. Howard Cole. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
