Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
TCC Complex Projection : Cast as Date
Summary
Need help in converting concatenated string into a date formatContent
Hi All,
I am using complex projection to concatenate YYYY from sysdate with a string (-07-01) which results in 2020-07-01 in the output file. But i need to convert this as a date. I am trying to use castAsDate function but i receive the following error: ORA-01861: literal does not match format string
Please help solving this error. Check the complex projection.
<quer:projection alias="DateCustom" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:castAsDate>
<quer:concatenate>
<quer:customFunction name="TO_CHAR">
<quer:date type="now"/>
Tagged:
1