title: PreparedStatement and setTimestamp in oracle jdbc
body: <p>I am using PreparedStatement with Timestamp in where clause:</p>
  
  <pre><code>PreparedStatement s=c.prepareStatement("select value,utctimestamp from t where utctimestamp&gt;=? and utctimestamp&lt;?"); 
  s.setTimestamp(1, new Timestamp(1273017600000L));   //2010-05-05 00:00 GMT
  s.setTimestamp(2, new Timestamp(1273104000000L));   //2010-05-06 00:00 GMT
  ResultSet rs = s.executeQuery();
  if(rs.next()) System.out.println(rs.getInt("value"));
  </code></pre>
  
  <p>The result I get is different, when I have different time zones on the client computer. Is this a bug in Oracle jdbc? or correct behavior?</p>
  
  <p>Oracle database version is 10.2 and I have tried with oracle jdbc thin driver version 10.2 and 11.1.</p>
  
  <p>The parameter is Timestamp, and I expected that no time conversions will be done on the way. The database column type is DATE, but I also checked it with TIMESTAMP column type with the same results.</p>
  
  <p>Is there a way to achieve correct result? I cannot change default timezone in the the whole application to UTC.</p>
  
  <p>Thanks for your help</p>