On Mon, Aug 28, 2006 at 04:18:12PM +0200, Bjørn T Johansen wrote: > On Mon, 28 Aug 2006 07:20:02 -0600 Michael Fuhr <[EMAIL PROTECTED]> wrote: > > select extract(epoch from sum(Til - Fra)) * 1000.0 ... > > Do you know if this is supported on older versions of PostgreSQL > as well? (eg. 7.4.x)
Yes, it is; I think it's worked since ancient times. See "Date/Time Functions and Operators" in the "Functions and Operators" chapter of the documentation for whatever versions you need. Here's a link for 7.4: http://www.postgresql.org/docs/7.4/interactive/functions-datetime.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
