mike <mike(at)bristolreccc(dot)co(dot)uk> writes:
> I have an interval field which is used to calculate total hours.
> At present it outputs as days hours minutes
> Is there any way to output as total hours
You could always EXTRACT(EPOCH ...) to get total seconds and then
divide. I am not sure whether EXTRACT(HOUR ...) would give the
same answer, or just the hours portion of the normal printout.
But anyway, see EXTRACT.
regards, tom lane