오라클 시간차이

오라클 시간 차이 구하기

SELECT 

       TRUNC(EndDate - StartDate) as "일", 
         TRUNC(((EndDate - StartDate) - TRUNC(EndDate - StartDate)) * 24) as "시간", 
         FLOOR(((((EndDate - StartDate) -TRUNC(EndDate - StartDate)) * 24) 
         - TRUNC(((EndDate - StartDate)-TRUNC(EndDate - StartDate)) * 24)) * 60) as "분"
       
  FROM (               
        SELECT TO_DATE('20090101 12:30','yyyymmdd hh24:mi') as StartDate,  -- 시작일
                       TO_DATE('20091001 17:20','yyyymmdd hh24:mi') as EndDate    -- 종료일
             FROM DUAL
        )