In response to Tom Lane <[EMAIL PROTECTED]>: > 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?
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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
