Обсуждение: total time more than 24 hours

Поиск
Список
Период
Сортировка

total time more than 24 hours

От
avpro avpro
Дата:
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?
thank you.

Re: total time more than 24 hours

От
Sameer Kumar
Дата:

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.
>

Re: total time more than 24 hours

От
Sameer Kumar
Дата:


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