Oliver Elphick <[EMAIL PROTECTED]> writes: > On Tue, 2002-09-03 at 11:45, Doppelganger wrote: >> How can I convert sum(interval) to seconds?
> Here's one way;
> junk=# select extract (minute from sum(if)) * 60 + extract (second
> from sum(if)) from i;
EXTRACT(EPOCH FROM interval) is designed for this ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
