In response to Howard Cole <howardnews@selestial.com>:
>
> 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?
SELECT CAST(time_in_minutes || ' minutes' AS INTERVAL) FROM test;
--
Bill Moran
http://www.potentialtech.comhttp://people.collaborativefusion.com/~wmoran/
