On 14 September 2010 13:57, Howard Cole <howardn...@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?
>
>  <http://www.postgresql.org/mailpref/pgsql-general>


select 1440 * interval '1 minute';

regards
Szymon Guz

Reply via email to