"Vanole, Mike" <mike.vanole@attws.com> 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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedMar 23, '04 at 11:54p
activeMar 26, '04 at 8:39p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase