SQL 시각 계산 팁

SQL에서 n분, n초 전..

-- 현재 시각: 2026/05/19 16:29:35
SELECT SYSDATE FROM DUAL;

-- 1시간전: 2026/05/19 15:29:35
SELECT SYSDATE - (1/24) FROM DUAL;

-- 1분전: 2026/05/19 16:28:35
SELECT SYSDATE - (1/1440) FROM DUAL;

-- 1초전: 2026/05/19 16:29:14
SELECT SYSDATE - (1/86400) FROM DUAL;