Dear all, I have trouble with the %Date object. I would like to make the following SQL statement:
"SELECT * FROM table WHERE table.Date BETWEEN :dateStart AND :dateEnd" :dateStart and :dateEnd are variables I put as parameters into the ClassMethod. They are from the type java.sql.date. The problem is, that I get "TRUE" whatever I put in and whatever is in the database. When I read the value of the "table.Date", I see that this is a completely different value than in the database. In the database I have 2004-08-13, what it writes out is 1841-12-25. How can I compare the java.sql.date with the dates in the database? Or do I make something else wrong?? Thank you. Muzaffer
