Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Data Sync Date Variable
Summary
Data Sync Date VariableContent
Hi,
I created a Variable "$$INITIAL_EXTRACT_DATE" with Below details
While trying to use this variable in date comparison or insert the value in a Date field getting below Error.
"ORA-01858: a non-numeric character was found where a numeric was expected".
When i check the log file the value is coming as TO_DATE('$$20060101IAL_EXTRACT_DATE','MM-DD-YYYY HH24:MI:SS') AS "EXTRACT_DATE"
Thanks
0