Re: How to reformat output of "age()" function

[Ron <ronljohnsonjr@xxxxxxxxx>]

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.