TCC complex export projection
Summary
Complex projection to output system date as a date stamp on output fileContent
Hello - I'm trying to write a complex projection to output the system date as a date stamp on the output file but receive the following error in TCC: ORA-00936: missing expression. The complex projection i'm using is below. Any suggestions as to how to export todays system date as a formatted date field?
<quer:projection alias="Date" projectedValueType="string" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:customFunction name="TO_CHAR">
<quer:date type="now"/>
<quer:string>yyyy-MM-dd</quer:string>
</quer:customFunction>
0