Oracle / PLSQL: ORA-00975 Error Message

Learn the cause and how to resolve the ORA-00975 error message in Oracle.

Description

When you encounter an ORA-00975 error, the following error message will appear:

• ORA-00975: date + date not allowed

Cause

You tried to add two dates together. This is not allowed. You can only add numeric values to dates.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Re-write your expression so that a numeric value is added to the date.

For example, if you tried to execute the following SQL statement:

SELECT sysdate + sysdate
FROM dual;

You would receive the following error message:

You could correct this error by substituting one date with a numeric value such as:

SELECT sysdate + 365
FROM dual;