Answers for "how to convert number to hours and minutes in oracle sql"

SQL
1

how to convert number to hours and minutes in oracle sql

WITH c AS (SELECT 492 AS MINUTES FROM DUAL)
SELECT trim(to_char(trunc(MINUTES / 60), '09')) || ':' ||
       trim(to_char(trunc(mod(abs(MINUTES), 60)), '09')) AS HHMM
FROM c;																-- 08:12
Posted by: Guest on June-07-2021

Code answers related to "how to convert number to hours and minutes in oracle sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language