Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group