낙서장/Oracle
SQL 날짜 계산
RunTimeException
2022. 2. 23. 10:57
SELECT TO_CHAR((SYSDATE + 1/24),'YYYY-MM-DD HH24:MI') FROM DUAL; -- 1시간
SELECT TO_CHAR((SYSDATE + 1/24/60),'YYYY-MM-DD HH24:MI') FROM DUAL; -- 1분
SELECT TO_CHAR((SYSDATE + 1/24/60/60),'YYYY-MM-DD HH24:MI') FROM DUAL; -- 1초