Date query not working inside java
930431Apr 13 2012 — edited Apr 13 2012Hi All,
I'm trying to run below query inside my java code but it's giving me error that - SQL syntax error: the token "(" was not expected here
select * from TIMINGTABLE WHERE COUNTRY = 'USA' AND TO_CHAR(RE_DATE, 'MM/DD/YYYY') >= '04/11/2012' ORDER BY COUNTRY
here, RE_DATE is a date field and data is saved as mm/dd/yyyy format into it.
Pls help.
_ prodyut