Bill Moran <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend