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