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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to reformat output of "age()" function
Date: 2019-09-11 15:46:05
Message-ID: c3b75ea3-58d5-4637-6023-d258a7c12e54@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Basques, Bob (CI-StPaul) 2019-09-11 16:12:21 Re: How to reformat output of "age()" function
Previous Message David Gauthier 2019-09-11 15:38:44 How to reformat output of "age()" function