DB/Oracle

[Oracle] TIMESTAMP, INTERVAL

냐옴 2016. 12. 1. 18:47

--시간차가 5분 미만인 건

AND REG_TS - TO_TIMESTAMP('2016/11/04 15:05:19', 'YYYY/MM/DD HH24:MI:SS') < INTERVAL '05:00' MINUTE TO SECOND