hai to every one ,
i getting error while getting data from database.
i used the data dictionary prospective devloped table.
and inserted data to table. in that i have the date field.
i assigned in that as type = Date
then i wriiten method in java to retrive the data by Date criteria it showing Error like as follow.
i used the date type in java as Java.sql.date.
when assigned to TaskDate in dictionary date type.
what i need to do help me. pl
The SQL statement "SELECT * FROM "TASK_DETAILS" WHERE "TASK_RECEIPT_DATE" = '2008-09-24' ORDER BY 1,2" contains the semantics error[s]: - 1:34 - type check error: the left hand side >>"TASK_DATE"<< (DATE) and the right hand side >>'2008-09-24'<< (CHAR) of a comparison operator are not comparable