Retrieving INTERVAL as float hours?

----- Original Message -----
From: "Ken Causey" <ken@premiernet.net>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, July 12, 2000 6:14 PM
Subject: [GENERAL] Retrieving INTERVAL as float hours?

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

ikar=# SELECT DATE_PART('epoch', '2 hours 30 minutes'::interval) / 3600;
?column?
----------
2.5
(1 row)

Alex Bolenok