Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Unable to convert a varchar field in database to date data type in OAC — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to convert a varchar field in database to date data type in OAC

Received Response
8
Views
8
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 8 comments

Summary

I 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

Content

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). 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!