[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

UNION ALL SELECT  SYSDATE-1/24/60  TIME, '1분전' 날짜 FROM DUAL

UNION ALL SELECT  SYSDATE  TIME ,  '현재시간' 날짜 FROM DUAL

 

 

 

*오라클 현재  분에 해당하는 데이터만 조회

SELECT * FROM (

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

UNION ALL SELECT  SYSDATE-1/24/60  TIME, '1분전' 날짜 FROM DUAL

UNION ALL SELECT  SYSDATE  TIME ,  '현재시간' 날짜 FROM DUAL

) X

WHERE TO_CHAR(X.TIME,'yyyymmdd hh24mi') = TO_CHAR(SYSDATE,'yyyymmdd hh24mi')

;