ORA-00975: date + date not allowed

HashFlare

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