Retrieving INTERVAL as float hours?

Поиск
Список
Период
Сортировка
От Ken Causey
Тема Retrieving INTERVAL as float hours?
Дата
Msg-id 3.0.1.32.20000712091410.017c4b08@premiernet.net
обсуждение исходный текст
Список pgsql-general
This may be a stupid question, and feel free to RTFM me, but please
specify the manual/book as I can't seem to find this.  I want
to retrieve an INTERVAL (the sum of INTERVALS actually) as a float
hour.  In other words if I normally get an output like

@ 2 hours 30 minutes

I would like

2.5

Thanks in advance for all help.

Ken Causey


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

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: [HACKERS] pg_dump & blobs - editable dump?
Следующее
От: Philip Warner
Дата:
Сообщение: Re: RE: [HACKERS] pg_dump & blobs - editable dump?