I had the same problem and wrote a small function
create function hours(timestamp without time zone, timestamp without time zone) RETURNS integer as
$$select cast( (cast($2 as date) - cast($1 as date)) * 24 + extract(hour from cast($2 as time) - cast($1 as time)) as integer)$$ language SQL IMMUTABLE;
Andrei
Jake Stride wrote:
Is there a way to convert in interval into hours? I have a table that records the amount of time worked by a person and want to sum up all the hours, however with the column being an interval once you reach more than 24 hours it turns that into a day. This is not what I want so instead of outputting 1day 2:00:00 I would want to output 26:00:00 is this possible?
Thanks
Jake
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.3 - Release Date: 4/25/2005
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
