getting extract to always return number of hours - Mailing list pgsql-sql

Hi,

I'm trying to get extract() to always return the number of hours between 
two time intervals, ala:

=> create table t1(timestart timestamp, timeend timestamp);
=> insert into t1(timestart, timeend) values ('2010-01-01 00:00:00', 
'2010-01-02 01:00:00');

=> select timeend - timestart from t1;    ?column?
---------------- 1 day 01:00:00
(1 row)

to return 25 hours.

I couldn't see anything in the docs and can't work out a way to do it.

Any suggestions?

Thanks!
-- 
Postgresql & php tutorials
http://www.designmagick.com/