[oracle]날짜의 시간 간격 구하기

#시간 간격

SELECT ROUND(((TO_DATE('20200319161310', 'YYYYMMDDHH24MISS')-TO_DATE('20200319141310', 'YYYYMMDDHH24MISS'))*24),3) AS INTERVAL_HOUR FROM DUAL ;

 

#분 간격

SELECT ROUND(((TO_DATE('20200319161310', 'YYYYMMDDHH24MISS')-TO_DATE('20200319141310', 'YYYYMMDDHH24MISS'))*24*60),3) AS INTERVAL_MINUTE FROM DUAL ;

 

#초 간격

SELECT ROUND(((TO_DATE('20200319161310', 'YYYYMMDDHH24MISS')-TO_DATE('20200319141310', 'YYYYMMDDHH24MISS'))*24*60*60),3) AS INTERVAL_SECOND FROM DUAL ;