Re: Retrieving INTERVAL as float hours?

----- Original Message -----
From: "Ken Causey" <ken(at)premiernet(dot)net>
To: <pgsql-general(at)postgresql(dot)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