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

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

Received Response
9
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!