I have done exactly the same what was described in blog /people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database
My XML SQL part is
<access>
...
<M_BIRTDAY hasQuot="NO">TO_DATE('12.12.2003','DD.MM.YYYY')</M_BIRTDAY>
</access>
But I am always gettion an error java.sql.SQLException: ORA-00907: missing right parenthesis
How to solve this problem? How to trace SQL of Adapter?