Postgres Pro
Downloads
Home   >   mailing lists

format return of "age" to hh:mm - Mailing list pgsql-general

From David Gauthier
Subject format return of "age" to hh:mm
Date
Msg-id CAMBRECB7TGJzy5X7i3XBopz2q5qhR1Di358upEKmLukpWBjWdQ@mail.gmail.com
Whole thread Raw
Responses Re: format return of "age" to hh:mm  (Ray O'Donnell <ray@rodonnell.ie>)
Re: format return of "age" to hh:mm  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: format return of "age" to hh:mm  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hi:

How does one reformat the output of the "age" function to always be in terms of hours:mins.

E.g. 

dvdb=> select age('2020-03-05 01:40:32-05','2020-03-01 21:56:05-05');
       age      
-----------------
 3 days 03:44:27
(1 row)

I want...

"75:44"

I'm not married to "age"  If there's a better way to do this that's fine too.

Thanks in advance !  

pgsql-general by date:

Previous
From: Kevin Brannen
Date:
Subject: RE: trouble making PG use my Perl
Next
From: "David G. Johnston"
Date:
Subject: Re: A question about the number of times a trigger will fire