Postgres Pro
Downloads
Home   >   mailing lists

Re: How to reformat output of "age()" function - Mailing list pgsql-general

From Ron
Subject Re: How to reformat output of "age()" function
Date
Msg-id c3b75ea3-58d5-4637-6023-d258a7c12e54@gmail.com
Whole thread Raw
In response to How to reformat output of "age()" function  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
Tree view
On 9/11/19 10:38 AM, David Gauthier wrote:
How can I change the default output of the "age" function to be, for example, in minutes?

E.g.
dvdb=> select age('2019-09-11 09:00:00','2019-09-09 11:00:00');
      age      
----------------
 1 day 22:00:00
(1 row)

I want the equivalent of that time delta in minutes.

This SO answer might help: https://stackoverflow.com/a/24930139/1543618

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: How to reformat output of "age()" function
Next
From: "Basques, Bob (CI-StPaul)"
Date:
Subject: Re: How to reformat output of "age()" function