title: getting java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected
body: <p>i am trying to run the below query i am getting the a non-numeric character was found where a numeric was expected here is the query</p>
  
  <pre><code>select * from schedule where to_date(SHDL_STRT_TIME,'dd-MON-yy HH24:mi:ss')                                            
  IN('11-Jan-15 20:30:00','11-Jan-15 08:00:00','11-Jan-15 20:00:00')
  </code></pre>
  
  <p>and <code>shdl_strt_time</code> is of type <code>DATE</code> object  it works fine in sqldeveloper but from application its not working</p>
  
  <p>Please clarify where I am going wrong, any help would be appreciated. Thank You</p>