Re: interval as hours or minutes ?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: interval as hours or minutes ?
Дата
Msg-id 20070207212519.GA14268@wolff.to
обсуждение исходный текст
Ответ на interval as hours or minutes ?  (Aarni Ruuhimäki <aarni@kymi.com>)
Список pgsql-sql
On Wed, Feb 07, 2007 at 19:03:35 +0200, Aarni Ruuhimäki <aarni@kymi.com> wrote:
> 
> Could anyone please tell an easy way to get total hours or minutes from an 
> interval ?

Extract the epoch from the interval and divide by the number of seconds
in the period of time that applies and apply appropiate rounding.


В списке pgsql-sql по дате отправления: