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@senokian.com
