oracle 시간

[ORACLE] 시간 컨트롤

* 오라클 1초, 10초, 20초, 1분전 데이터 조회 SELECT SYSDATE -1/60/24/60 TIME, '1초전' 날짜 FROM DUAL UNION ALL SELECT SYSDATE-20/60/24/60 TIME, '20초전' 날짜 FROM DUAL UNION ALL SELECT SYSDATE-30/60/24/60 TIME, '30초전' 날짜 FROM DUAL UNION ALL SELECT SYSDATE-40/60/24/60 TIME, '40초전' 날짜 FROM DUAL UNION ALL SELECT SYSDATE-50/60/24/60 TIME, '50초전' 날짜 FROM DUAL UNION ALL SELECT SYSDATE-60/60/24/60 TIME, '60초전' 날짜 FROM DUAL ..