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
