Re: total time more than 24 hours

Поиск
Список
Период
Сортировка
От Sameer Kumar
Тема Re: total time more than 24 hours
Дата
Msg-id CADp-Sm5VJ=H+mjYJKgv8boogLyFi-wUW8CiAMzQxrTbS94S-KA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: total time more than 24 hours  (Sameer Kumar <sameer.kumar@ashnik.com>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Persson
Дата:
Сообщение: Returning NULL from SRF
Следующее
От: Magnus Persson
Дата:
Сообщение: Re: Returning NULL from SRF