Re: Int to Interval conversion

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.com
http://people.collaborativefusion.com/~wmoran/