Oracle Analytics Cloud and Server

Products Banner

Data Sync Date Variable

Received Response
22
Views
1
Comments

Summary

Data Sync Date Variable

Content

Hi,

I created a Variable "$$INITIAL_EXTRACT_DATE" with Below details

image

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

Answers