"Vanole, Mike" <[EMAIL PROTECTED]> writes: > I'm trying to query two timestamp(0) columns to determine elapsed time. I u= > se the age() function which works fine, but I want to return the informatio= > n in MINUTES.=20
Just subtract (giving an interval), use extract(epoch) to get the interval in seconds, then divide by 60 and round (or truncate if you prefer). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]