In response to Tom Lane <tgl@xxxxxxxxxxxxx>: > 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? Well, that's more or less what I've been doing (although the EPOCH thing shortened the code up a bit, thanks!). It just seemed like this would be something so common that there'd be something in existence already. I guess I was wrong. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
