날짜의 일자 및 시간 차이 구하기

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('2013-08-07','yyyy-mm-dd') AS STARTDATE,  -- 시작일
        TO_DATE('2013-12-30','yyyy-mm-dd') AS ENDDATE    -- 종료일
  FROM DUAL
);