title: java.sql.SQLException: ORA-01843: not a valid month error - date format conversion issue
body: <p>I'm having a strange issue here with a query from which I'm trying to pull data queried by start and end date parameters.</p>
  
  <p>I'm conducting the following.</p>
  
  <pre><code>SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
  String preparedQuery = "SELECT ID, FULNAME, FRMEMAIL,    LOCATION,TYPE1,TYPE2,BORROWER_NAME,LOAN_NUM,TIME_REQ
  FROM FORM_REDUCVU WHERE to_date(TIME_REQ,'yyyy-mm-dd') &gt;= ?  AND to_date (TIME_REQ,'yyyy-mm-dd') &lt;= ? ORDER BY ID DESC";
  java.util.Date util_StartDate = sdf.parse( request.getParameter("time_req_date") );
  java.sql.Date timreq_datevar1 = new java.sql.Date( util_StartDate.getTime() );
  java.util.Date util_EndDate = sdf.parse( request.getParameter("time_req_date2") );
  java.sql.Date timreq_datevar2 = new java.sql.Date( util_EndDate.getTime() );
  out.println("datestamp java time vals "+timreq_datevar1 + " " + timreq_datevar2);
  PreparedStatement prepstmt = connection.prepareStatement(preparedQuery);
  prepstmt.setDate(1, timreq_datevar1);
  prepstmt.setDate(2, timreq_datevar2);
  </code></pre>
  
  <p>And the out.print values will give something like 2018-10-09 and 2019-02-20.
  This does match the date picker selections I'm making, which are in mm/dd/yyyy format, i.e. 10/09/2018 and 02/20/2019.</p>
  
  <p>Now the above returns no errors in the log, but no data either. But I did have the SQL query as  " 
      <code>WHERE to_datechar(TIME_REQ,'mm/dd/yyyy') &gt;= ? AND to_char(TIME_REQ,'mm/dd/yyyy') &lt;= ?</code></p>
  
  <p>When changing to this above, I get the error in the topic of not a valid month.</p>
  
  <p>I would have thought the SimpleDateFormat class would have parsed the date to mm/dd/yyyy in pattern, but it seems to make the java.slq.Date object pattern hyphenated, like yyyy-mm-dd.</p>
  
  <p>Am I not parsing it correctly? Or is this going to require a different class or package, like java.Time? I would thought this would work, but there has to be some small conversion method not working.
  Bottom line - I'd really prefer to keep the jQuery date pickers with their mm/dd/yyyy formats in tact, and be able to query by these entries.
  Any input regarding this is welcomed.
  Thank you! </p>