Home > mailing lists

time duration - Mailing list pgsql-novice

From	Wright, George
Subject	time duration
Date	November 28, 2007 15:34:12
Msg-id	51548D6D5BEB57468163194A8C1A0E985826B9@MAGPTCPEXC02.na.mag-ias.net Whole thread Raw
In response to	Re: psql: FATAL: Ident authentication failed for user "jira" (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-novice

Tree view

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?

pgsql-novice by date:

From: "Sean Davis"
Date: 28 November 2007, 11:42:51
Subject: Re: users table and user_details table? Bad form?

From: "Greg Cocks"
Date: 30 November 2007, 18:54:53
Subject: Group Roles are now Login Roles in pgAdmin?

time duration - Mailing list pgsql-novice

Previous

Next