Tag Archives: ORA-00975

ORA-00975: date + date not allowed

oracle

ORA-00975: date + date not allowed
Cause: An attempt was made to add two date fields together. Dates may be added only to numeric fields, not to other dates
Action: Use the Oracle function TO_NUMBER to convert one of the date fields to a numeric field before adding it to the other date field

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/