Currently having Minutes(bigint
) as
390
I want to convert this Minutes to hours. Is there any function to convert it?
Eg: 390 as 6.30
Something like this should work:
SELECT TO_CHAR('390 minute'::interval, 'HH24:MI')...
From an answer to a related question: PostgreSQL - How to convert seconds in a numeric field to HH:MM:SS
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With