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/