title: Solr DataImportHandler incorrect Oracle date in index
body: <p>I use Solr 3.4 to index field retrieved from oracle 10 database by DataImportHandler. Oracle field of type "DATE" has value: 2011-09-20. Solr index field of type "solr.TrieDateField" has value 2011-09-19T22:00:00Z. My (oracle, solr, windows) timezone is GMT+1. I expected to have solr index field value: 2011-09-19T23:00:00Z. Why it's not?</p>
  
  <p>Config:</p>
  
  <pre><code>&lt;dataConfig&gt;
      &lt;dataSource driver="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:***" user="" password="" /&gt;
      &lt;document&gt;
          &lt;entity name="event" query="select start_date from event" &gt;
          &lt;/entity&gt;
      &lt;/document&gt;
  &lt;/dataConfig&gt;
  </code></pre>
  
  <p>I use ojdbc14 version 11.2.0.2</p>
  
  <p>Solr admin -> java properties -> user.timezone = Europe/Belgrade (which is GMT+1)</p>
  
  <p>After research I've found possible cause:</p>
  
  <pre><code>select DBTIMEZONE, SESSIONTIMEZONE from dual;
  1. +2:00 +01:00
  </code></pre>
  
  <p>Is solr using dbtimezone instead of sessiontimezone?</p>
  
  <p>I've found the answer: </p>
  
  <pre><code>SELECT FROM_TZ(timestamp '2011-08-20 00:00:00', 'CET') AT TIME ZONE 'GMT' from dual;
  11/08/19 22:00:00,000000000 GMT
  SELECT FROM_TZ(timestamp '2011-12-20 00:00:00', 'CET') AT TIME ZONE 'GMT' from dual;
  11/12/19 23:00:00,000000000 GMT
  </code></pre>
  
  <p>First date includes Daylight Saving Time, second does not. So obvious.</p>