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-Sm5VJ=H+mjYJKgv8boogLyFi-wUW8CiAMzQxrTbS94S-KA@mail.gmail.com
Whole thread Raw
In response to Re: total time more than 24 hours  (Sameer Kumar <sameer.kumar@ashnik.com>)
List pgsql-novice


On Sun, Jan 5, 2014 at 10:37 PM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:

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


Refer to this documentation:

> thank you.
>


Regards
Sameer

pgsql-novice by date:

Previous
From: Magnus Persson
Date:
Subject: Returning NULL from SRF
Next
From: Magnus Persson
Date:
Subject: Re: Returning NULL from SRF