[Oracle] 시간 또는 분 숫자를 HH:mm 형식으로

[Oracle] 시간 또는 분 숫자를  HH:mm 형식으로

 

-- 시간(숫자) => HH:mm ( 예: 2.6 => 02:36 ) SELECT TO_CHAR(TRUNC(2.6),'00') || ':' || REPLACE(TO_CHAR(EXTRACT (MINUTE FROM NUMTODSINTERVAL(2.6, 'HOUR' )),'00'),' ','') FROM DUAL; -- 분숫자 => HH:mm ( 예: 72 => 01:12 ) SELECT TO_CHAR(TRUNC(72/60),'00') || ':' || REPLACE(TO_CHAR(EXTRACT (MINUTE FROM NUMTODSINTERVAL(72, 'MINUTE' )),'00'),' ','') FROM DUAL;