How to convert Hours to Numeric in PostgreSQL
Solution 1:
You could do:
extract(epoch from mycol) / 60 / 60
This converts the time to a number of seconds, and then to the corresponding number of hours.
How to convert Hours to Numeric in PostgreSQL
Solution 1:
You could do:
extract(epoch from mycol) / 60 / 60
This converts the time to a number of seconds, and then to the corresponding number of hours.