Bill Moran <wmoran@collaborativefusion.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