WITH t AS
(
SELECT '15:00' tm FROM dual
UNION ALL SELECT '18:00' FROM dual
UNION ALL SELECT '23:00' FROM dual
)
SELECT FLOOR(x/24/60/60) days
, TO_CHAR(TO_DATE(MOD(x, 24*60*60), 'sssss'), 'hh24:mi') hours
FROM (SELECT SUM(TO_CHAR(TO_DATE(tm, 'hh24:mi'), 'sssss')) x FROM t)
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.