How do I convert an interval into a number of hours with postgres? November 2, 2022 by Tarik Probably the easiest way is: SELECT EXTRACT(epoch FROM my_interval)/3600