Skip to Content
0
Former Member
Sep 25, 2008 at 07:05 AM

Date Exception

61 Views

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