Re: total time more than 24 hours - Mailing list pgsql-novice

From Sameer Kumar
Subject Re: total time more than 24 hours
Date
Msg-id CADp-Sm42MChH2Ae9_G2BtKKam5OvgFVjs5_7uooLYrQ9DnofJg@mail.gmail.com
Whole thread Raw
In response to total time more than 24 hours  (avpro avpro <avprowebeden@gmail.com>)
Responses Re: total time more than 24 hours
List pgsql-novice

Regards
Sameer

PS: Sent from my Mobile device. Pls ignore typo n abb
On 5 Jan 2014 22:32, "avpro avpro" <avprowebeden@gmail.com> wrote:
>
> hi,
>
> I would like to have a table with one field storing time values greater than 24 hours.
> for example: 53:42 (53 hrs and 42 min). how could i do this?

Its not 'TIME' but 'TIME INTERVAL' that you want to use. Try interval data type in postgreSQL

> thank you.
>

pgsql-novice by date:

Previous
From: avpro avpro
Date:
Subject: total time more than 24 hours
Next
From: Magnus Persson
Date:
Subject: Returning NULL from SRF