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!
Unable to convert a varchar field in database to date data type in OAC
SummaryI am creating a dataset from a table in database that has a date field in varchar2 datatype. I am unable to convert it to date datatype in OAC
I am creating a dataset in OAC connecting to a table in database that has a date field in varchar2 datatype. I am unable to convert it to "date" datatype in OAC. I get a query error.
I am trying to use the "Cast(expression as type)" function in data flow to do this conversion. My expression looks like 'Cast(RECORD_DATE AS DATE)'.
When i Validate this expression and Apply, it succeeds. However there is a query error that shows up in the "preview data" section (attached image).