Casting VARCHAR to DATE in OBIEE Report
735477Jan 8 2010 — edited Mar 15 2011Hi,
When I change the datatype from VARCHAR to DATE (using CAST() function) on my report. I am not getting the results.
Error: Datetime value 08/20/2009 from 08/20/2009 does not match the specified format. (HY000)
I tried to change the datatype of the field in the metadata physical layer. But it only got three options as Type: DOUBLE, UNKNOWN, VARCHAR...so there is no DATE datatype. I also enabled the CAST_SUPPORTED DB feature in the Subject Area too, Did not worked!
FYI: We import data from SAP, it all comes in as either VARCHAR or INTEGER.
Thanks in advance!