title: How to set jdbc/partitionColumn type to Date in spark 2.4.1
body: <p>I am trying to retrieve data from oracle using spark-sql-2.4.1 version.
  I tried to set the JdbcOptions as below :</p>
  
  <pre><code>    .option("lowerBound", "31-MAR-02");
      .option("upperBound", "01-MAY-19");
      .option("partitionColumn", "data_date");
      .option("numPartitions", 240);
  </code></pre>
  
  <p>But gives error :</p>
  
  <pre><code>    java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
          at java.sql.Timestamp.valueOf(Timestamp.java:204)
          at org.apache.spark.sql.execution.datasources.jdbc.JDBCRelation$.toInternalBoundValue(JDBCRelation.scala:179)
  </code></pre>
  
  <p>Then tried as below</p>
  
  <pre><code>    .option("lowerBound", "2002-03-31"); //changed the date format
      .option("upperBound", "2019-05-02");
      .option("partitionColumn", "data_date"); 
      .option("numPartitions", 240);
  </code></pre>
  
  <p>Still no luck.
  So what is the correct way to pass the date as "lower/upperBound"?
  Is there a way to specify/set option parameter data Type ?</p>
  
  <p><strong>Part-2</strong>
  Checked the options properly.
  they were overwritten in between before executing the query.
  So corrected it. ... now that error resolved.</p>
  
  <p>But  for below options:</p>
  
  <pre><code>.option("lowerBound", "2002-03-31 00:00:00"); 
  .option("upperBound", "2019-05-01 23:59:59");
  .option("timestampFormat", "yyyy-mm-dd hh:mm:ss");
  </code></pre>
  
  <p>Query String : </p>
  
  <pre><code>query -&gt;  ( SELECT * FROM MODEL_VALS ) T
  </code></pre>
  
  <p>It is throwing another error :</p>
  
  <pre><code>java.sql.SQLException: ORA-12801: error signaled in parallel query server P022, instance nj0005
  
  ORA-01861: literal does not match format string
  </code></pre>