How do I convert an interval into a number of hours with postgres

Question

Say I have an interval like  4 days 10 00 00   in postgres  How do I convert that to a number of hours  106 in this case   Is there a function or should I bite the bullet and do something like  extract days  my interval    24   extract hours  my interval

User · Answer

If you want integer i e  number of days   SELECT  EXTRACT epoch FROM  SELECT  NOW   -  2014-08-02 08 10 56     86400   int

User · Answer

Probably the easiest way is   SELECT EXTRACT epoch FROM my interval  3600

User · Answer

If you convert table field    Define the field so it contains seconds    CREATE TABLE IF NOT EXISTS test                 field        INTERVAL SECOND 0       Extract the value  Remember to cast to int other wise you can get an unpleasant surprise once the intervals are big   EXTRACT EPOCH FROM field   int

User · Answer

select date  now    - date  1955-12-15     Here is the simple query which calculates total no of days

User · Answer

select floor  date part  epoch   order time -  2016-09-05 00 00 00     3600    count    from od a week group by floor  date part  epoch   order time -  2016-09-05 00 00 00     3600      The   int conversion follows the principle of rounding  If you want a different result such as rounding down  you can use the corresponding math function such as floor

User · Answer

To get the number of days the easiest way would be   SELECT EXTRACT DAY FROM NOW   -  2014-08-02 08 10 56      As far as I know it would return the same as   SELECT  EXTRACT epoch FROM  SELECT  NOW   -  2014-08-02 08 10 56     86400   int

[datetime] How do I convert an interval into a number of hours with postgres?

Examples related to datetime

Examples related to postgresql

Examples related to intervals