Search Postgresql Archives

format return of "age" to hh:mm

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 !  

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux