Re: Int to Interval conversion - Mailing list pgsql-general

From Szymon Guz
Subject Re: Int to Interval conversion
Date
Msg-id AANLkTikha4=M=0Y=sr-O12Ky6V44CVEnVUrW0o+M26f+@mail.gmail.com
Whole thread Raw
In response to Int to Interval conversion  (Howard Cole <howardnews@selestial.com>)
List pgsql-general


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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Int to Interval conversion
Next
From: Adrian Klaver
Date:
Subject: Re: Int to Interval conversion