Return
-
Title
Error: "ORA-00904: "DATEADD": invalid identifier" when executing SQL with 'DateAdd' functions. -
Description
Error received when executing a SQL statement with the Oracle DateAdd function:
"ORA-00904: "DATEADD": invalid identifier"
To reproduce this error, execute Select DateADD(dd , -10, to_date(05/APR/2004)) from dual in a SQL Editor window.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.