시간계산 쿼리

SELECT BASE_DT

,PRJT_NM

,JOB_ID

,SQNC_NO

,STRN_DTTM

,END_DTTM

,EXCT_DTTM

,trunc( mod( (END_DTTM-STRN_DTTM)*24, 24 ) )|| --요거슨 HH

trunc( mod( (END_DTTM-STRN_DTTM)*24*60, 60 ) )|| --요거슨 MI

trunc( mod( (END_DTTM-STRN_DTTM)*24*60*60, 60 ) )     T --요거슨SS

,mod((END_DTTM-STRN_DTTM)*24,60)

FROM   TDWCMSETLJLOGI

WHERE  BASE_DT ='20130318' 

AND JOB_ID like '%TOA%'

order by 3