Value cannot be converted to requested type
hi.
can anyone tell me why i get the following error:
[sunm][Oracle JDBC Driver]Value can not be converted to requested type
I get this error when i try to execute a SQL query like the one below:
SELECT * FROM orders WHERE orders.date BETWEEN '20-SEP-05' AND '22-SEP-05'
this is not the exact query i am trying to excute, but serves the purpose of this forum post.
ideally, i'd like to use the "?" parameter instead of the dates written above. the application's user selects a StartDate and EndDate for his search. this should display a list of orders within that date range.
i have tried using several date formats, as well as the TO_DATE() function. i always get this error when using the "?" parameter but it displays the correct records when i use an actual date.
i also only get this error when working with dates. i can use the "?" parameter with no problems for any other table column.
someone please help!!
