time duration

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: time duration
Date: 2007-11-28 16:27:07
Message-ID: 51548D6D5BEB57468163194A8C1A0E985826B9@MAGPTCPEXC02.na.mag-ias.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I want to execute a query such as:

select abstime(1196474400) - abstime(1167616800);

but specify the result in total minutes, total days (rounding off hours,
minutes seconds).

I'm sure this is easy but I couldn't find it. What is the proper way to
do this in PostgreSQL?

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Greg Cocks 2007-11-30 19:54:49 Group Roles are now Login Roles in pgAdmin?
Previous Message Sean Davis 2007-11-28 12:42:46 Re: users table and user_details table? Bad form?