title: How to use CURRENT_TIMESTAMP in JDBC (Oracle DB)
body: <p>In MY_TABLE, when ORD_AMT field is updated then LST_UPDT_TS is updated with current_timestamp too. Presented by following query:</p>
  
  <pre><code>UPDATE MY_TABLE
  SET ORD_AMT = 50, LST_UPDT_TS = CURRENT_TIMESTAMP
  WHERE ORD_ID = 'ORD_123'
  </code></pre>
  
  <p>I need implement this business by JDBC code, and my Web server and DB server are difference timezone. If I pass Date().getTime() to JDBC, it's the current of Web server but I need the current time of DB server.</p>
  
  <p>Is there a way for passing CURRENT_TIMESTAMP like this:</p>
  
  <pre><code>preparedStatement = dbConnection.prepareStatement(updateOrderSql);
  preparedStatement.setFloat(1, 50);
  preparedStatement.setTimestamp(2, Timestamp.CURRENT_TIMESTAMP);
  preparedStatement.setString(3, 'ORD_123');
  preparedStatement.executeUpdate();
  </code></pre>
  
  <p>Thanks for your help.</p>