Re: interval conversion

Поиск
Список
Период
Сортировка
От Brett Dikeman
Тема Re: interval conversion
Дата
Msg-id 64358.63.142.161.101.1062085511.squirrel@frank.mercea.net
обсуждение исходный текст
Ответ на Re: interval conversion  (Tomasz Myrta <jasiek@klaster.net>)
Список pgsql-sql
>> I have a possibly stupid question- I'm doing some time calculations yielding
>> intervals, and for my purposes I need to convert the interval(say, "1 day 8
>> hours") into (floating point) hours.  While there's a plethora of handy
>> date_extract functionality and the like, I need a conversion.
>>
>> Any suggestions on how to accompish this?  Simpler the better, of course.
>
> extract(epoch from some_interval)/3600

[slaps head] I swear, I studied the date/time sections of the manual for quite
some time...really...Siiiigh :-)

Thanks Tomasz!

Brett


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

Предыдущее
От: "Chris Faulkner"
Дата:
Сообщение: Re: length of array
Следующее
От: Joe Conway
Дата:
Сообщение: Re: length of array