Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
time duration
- From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
- To: <pgsql-novice(at)postgresql(dot)org>
- Subject: time duration
- Date: Wed, 28 Nov 2007 10:27:07 -0600
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?
- References:
- Re: psql: FATAL: Ident authentication failed for user "jira"
- From: Tom Lane
- Re: psql: FATAL: Ident authentication failed for user "jira"
- Prev by Date: Re: users table and user_details table? Bad form?
- Next by Date: Group Roles are now Login Roles in pgAdmin?
- Previous by thread: Re: psql: FATAL: Ident authentication failed for user "jira"
- Next by thread: users table and user_details table? Bad form?
- Indexes: