how to write a query with Date type

[jill han]

Below is a piece of code to get records from a table and exception
// startDate and endDate are Date object
// aDate has Date data type in oracle db
String sql = "Select * from aTable ";
sql = sql + " Where aDate ";
sql = sql + " Between '" + startDate + "' And '" + endDate + "' ";
List sqlResult = aTablePeer.executeQuery(sql);

org.apache.torque.TorqueException: ORA-01858: a non-numeric character
was found where a numeric was expected


Thanks in advance.

Jill


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]