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