On Tuesday 14 September 2010 4:57:46 am Howard Cole wrote: > 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. test=> SELECT 1440 * interval '1 min'; ?column? ---------- 24:00:00 (1 row) -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
