Re: Int to Interval conversion

[Szymon Guz <mabewlun@xxxxxxxxx>]

On 14 September 2010 13:57, Howard Cole <howardnews@xxxxxxxxxxxxx> 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?

select 1440 * interval '1 minute'; 

regards

Szymon Guz