Oracle SYSDATE minus INTERVAL - Subtracting Time Units

Oracle’s SYSDATE function, combined with the INTERVAL keyword, provides a convenient way to manipulate dates and times.

Operations with SYSDATE on Oracle #

Here are examples of subtracting different time units from the current date and time.

Subtracting Months #

To subtract six months from the current date:

SELECT SYSDATE - INTERVAL '6' MONTH AS "Six Months Ago" FROM DUAL;

Subtracting Days #

To subtract 10 days from the current date:

SELECT SYSDATE - INTERVAL '10' DAY AS "Ten Days Ago" FROM DUAL;

Subtracting Hours #

To subtract 5 hours:

SELECT SYSDATE - INTERVAL '5' HOUR AS "Five Hours Ago" FROM DUAL;

Subtracting Minutes #

To subtract 15 minutes:

SELECT SYSDATE - INTERVAL '15' MINUTE AS "Fifteen Minutes Ago" FROM DUAL;

Conclusion #

These examples show how to use the INTERVAL keyword with SYSDATE to perform common date and time operations in Oracle. This approach is both intuitive and precise, allowing for clear and readable SQL queries when adjusting timestamps.