We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

TCC Complex Projection : Cast as Date

Received Response
14
Views
1
Comments
edited Oct 5, 2020 2:12PM in Taleo Enterprise Integrations 1 comment

Summary

Need help in converting concatenated string into a date format

Content

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"&gt;
  <quer:castAsDate>
    <quer:concatenate>
      <quer:customFunction name="TO_CHAR">
        <quer:date type="now"/>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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