Hi,

I'm trying to query two timestamp(0) columns to determine elapsed time. I use the age() function which works fine, but I want to return the information in MINUTES.

So...

sel age(endtime, starttime) returns 02:23:00, for example, or 2 days 03:05:03.

How can I get this to return 143 or 3065.nn - by my examples above - without parsing and substringing or extracting? Is there a clean way to "cast" this to minutes?

Thank you,
Mike

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 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