Can I ask why you're not just converting the value to a Java Date (either .sql. or .util.)?
Clinton -----Original Message----- From: Suhaib [mailto:[EMAIL PROTECTED] Sent: March-09-08 12:50 AM To: [email protected] Subject: Passing date as string to IBATIS. Hi all , I am using IBATIS 2.3.0 and oracle 10g. I have passed a date as string to select statments using IBATIS , the date format is dd Mon yy ,ex. 12 Mar 007, using IBATIS , there is no result return back from DB , but when i use any sql client I get the result from DB. SQL statement in IBATIS : The hireDate is String SELECT name, id from employee where to_char(HIRE_DATE ,'dd Mon yy' ) = to_char(#hireDate#) SQL statement in SQL client: SELECT name, id from employee where to_char(HIRE_DATE ,'dd Mon yy' ) = '12 Mar 07' OR SELECT name, id from employee where to_char(HIRE_DATE ,'dd Mon yy' ) = to_char ( to_date,'12 Mar 07','dd Mon yy'),'dd Mon yy') regards Suhaib -- View this message in context: http://www.nabble.com/Passing-date-as-string-to-IBATIS.-tp15924757p15924757. html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
