Ibatis and SQL TimeStamp

Question

I have a SQL with a where clause generating this error message :

com.ibm.db2.jcc.b.co: A statement contains a use of a parameter marker 
that is not valid.. SQLCODE=-418, SQLSTATE=42610, DRIVER=3.53.70

Where clause :

TIMESTAMP BETWEEN TIMESTAMP(#startDate#,'00.00.00') and TIMESTAMP(#endDate#,'23.59.59')

I would like to know if it is possible to insert #startDate inside TIMESTAMP function.

Answer 1

This is solved : TIMESTAMP BETWEEN TIMESTAMP('$startDate$','00.00.00') and TIMESTAMP('$endDate$','23.59.59') – xam7766 Dec 12 '11 at 14:15