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

October 12, 2022 by Tarik

Probably the easiest way is:

SELECT EXTRACT(epoch FROM my_interval)/3600