날짜함수이용-기간들의 합을 다시 날짜형식으로 변환

SELECT  TRUNC(B.TSUM)                           || ' 일 ' ||
        TRUNC(MOD((B.TSUM),1)*24)               || ' 시 ' ||
        TRUNC(MOD((B.TSUM)*24,1)*60)            || ' 분 ' ||
        TRUNC(ROUND(MOD((B.TSUM)*24*60,1)*60))  || ' 초 '       AS TRESULT
FROM    (
        SELECT  SUM(A.T2 - A.T1) AS TSUM
        FROM    (
                SELECT  'A001'                                          AS EMPNO,
                        TO_DATE('20060909133624','YYYYMMDDHH24MISS')    AS T1,
                        TO_DATE('20060910021244','YYYYMMDDHH24MISS')    AS T2
                FROM    DUAL
                UNION ALL
                SELECT  'A002'                                          AS EMPNO,
                        TO_DATE('20060909142314','YYYYMMDDHH24MISS')    AS T1,
                        TO_DATE('20060910122212','YYYYMMDDHH24MISS')    AS T2
                FROM    DUAL
                UNION ALL
                SELECT  'A003'                                          AS EMPNO,
                        TO_DATE('20060919132524','YYYYMMDDHH24MISS')    AS T1,
                        TO_DATE('20060922221434','YYYYMMDDHH24MISS')    AS T2
                FROM    DUAL
                )       A
) B
;

 

 

TRESULT
-------------------

4 일 19 시 24 분 28 초