That is helpful, I have created a slightly different function that returns an interval in the format HH:MM not sure if it will help anyone or anyone has any suggestions to improve it: create function hours(interval) returns varchar as 'SELECT floor(extract(epoch from $1)/3600) || \':\' || (cast(extract(epoch FROM $1) AS integer)%3600)/60;' language SQL IMMUTABLE; Thanks Jake Andrei Gaspar wrote: > 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 >> >> >> >> > > -- Jake Stride Senokian Solutions Ltd The TechnoCentre Coventry University Technology Park Puma Way Coventry CV1 2TT T: 0870 744 2030 F: 0870 460 2623 M: 07713 627 304 E: jake.stride@xxxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
