This is an example of how to use the Oracle TO_CHAR function in TCC:
<quer:projection alias="DateOfBirth"> <quer:customFunction name="TO_CHAR"> <quer:field path="Candidate,Birthday"/> <quer:string>MM/dd/yyyy</quer:string> </quer:customFunction> </quer:projection>