Mastering Oracle SYSDATE and Date Arithmetic
Performing Date Arithmetic with SYSDATE
Oracle's SYSDATE function returns the current date and time. You can add or subtract time intervals directly using arithmetic on date values, or use dedicated functions like ADD_MONTHS.
Adding Time Intervals
-- Add 1 year
SELECT SYSDATE, ADD_MONTHS(SYSDATE, 12) FROM DUAL;
-- Add 1 month
SELECT SYSDATE, A ...
Posted on Tue, 30 Jun 2026 17:03:48 +0000 by Lateuk