Postgres Pro
Downloads
Home   >   mailing lists

Convert interval to hours - Mailing list pgsql-general

From David Gauthier
Subject Convert interval to hours
Date
Msg-id CAMBRECASE0aEf28DTVpY58MDrZVP9nUcTPW7NJkwPv4uVk-oAw@mail.gmail.com
Whole thread Raw
Responses Re: Convert interval to hours  (Peter Kleiner <runtfan71@gmail.com>)
List pgsql-general
Tree view
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




pgsql-general by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: Slow shutdowns sometimes on RDS Postgres
Next
From: Peter Kleiner
Date:
Subject: Re: Convert interval to hours