title: Resultset.getDate() throwing exception java.lang.NumberFormatException: For input string: "Name of Month"
body: <p>When extracting date from database using <code>Resultset.getDate()</code>, I am getting the following exception:</p>
  
  <pre><code>java.lang.NumberFormatException: For input string: "Name of Month".
  </code></pre>
  
  <p>I can confirm that the exception is thrown when trying to get data from a column of Oracle date datatype.</p>
  
  <p>I can't paste the actual code here as it is very long. But the sample code is as given below</p>
  
  <pre><code>pstmnt = connection.prepareStatement(selectQuery);
  rs = pstmnt.executeQuery();
  while (rs.next()) {
      rs.getDate(column.getColName());
  }
  </code></pre>
  
  <p>Please help?</p>
  
  <p>As requested by Sanjay, please find the stack trace below</p>
  
  <pre><code>java.lang.NumberFormatException: For input string: "MAY"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:63)
      at java.lang.Integer.parseInt(Integer.java:481)
      at java.lang.Integer.parseInt(Integer.java:531)
      at java.sql.Date.valueOf(Date.java:200)
      at oracle.jdbc.driver.OracleStatement.getDateValue(OracleStatement.java:4610)
      at oracle.jdbc.driver.OracleResultSetImpl.getDate(OracleResultSetImpl.java:625)
      at oracle.jdbc.driver.OracleResultSet.getDate(OracleResultSet.java:1601)
      at quotecopy.DbConnection.getTableRows(DbConnection.java:126)
      at quotecopy.QuoteCopier.main(QuoteCopier.java:66)
  java.lang.NumberFormatException: For input string: "MAY"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:63)
      at java.lang.Integer.parseInt(Integer.java:481)
      at java.lang.Integer.parseInt(Integer.java:531)
      at java.sql.Date.valueOf(Date.java:200)
      at oracle.jdbc.driver.OracleStatement.getDateValue(OracleStatement.java:4610)
      at oracle.jdbc.driver.OracleResultSetImpl.getDate(OracleResultSetImpl.java:625)
      at oracle.jdbc.driver.OracleResultSet.getDate(OracleResultSet.java:1601)
      at quotecopy.DbConnection.getTableRows(DbConnection.java:127)
      at quotecopy.QuoteCopier.main(QuoteCopier.java:66)
  </code></pre>