■ INTERVAL 키워드 : 최근 5분 이내 데이터 조회하기

------------------------------------------------------------------------------------------------------------------------

 

SELECT *

FROM   JOB

WHERE  REQUEST_TIME BETWEEN CURRENT_TIMESTAMP - INTERVAL '50 MIN' AND CURRENT_TIMESTAMP

ORDER BY REQUEST_TIME DESC;

 

------------------------------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG