Bill Moran <wmoran(at)collaborativefusion(dot)com> writes:
> There seems to be a lack of useful functions for converting intervals
> to useful representations. For example, I want to display an interval
> in hours and fractions of hours only, not hours and minutes.
Perhaps EXTRACT(EPOCH ...) to get total seconds and then do some
arithmetic?
regards, tom lane