Convert interval to hours

From: David Gauthier <davegauthierpg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Convert interval to hours
Date: 2018-09-14 15:51:18
Message-ID: CAMBRECASE0aEf28DTVpY58MDrZVP9nUcTPW7NJkwPv4uVk-oAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

In perl/DBI, I have code that's getting me an "age" which returns something
like... "-17 days -08:29:35". How can I convert that to a number of hours
(as a float I would presume) ?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Kleiner 2018-09-14 15:55:18 Re: Convert interval to hours
Previous Message Jeremy Schneider 2018-09-14 15:43:12 Re: Slow shutdowns sometimes on RDS Postgres