title: How do I minus 2 hours from a date/time field in EVERY record in a table?
body: <p>I'm trying to offset a timezone error from PHP. All times recorded in table 'test' was ahead by two hours. What  I want is to update each record by minusing two hours from the time that is already there.</p>
  
  <p>I tried:</p>
  
  <pre><code>UPDATE test 
     SET LastModifiedDate = SUBTIME( LastModifiedDate, '02:00:00' ) 
  </code></pre>
  
  <p>But this just updates all fields with the same value.</p>
  
  <p>Please assist</p>
  
  <p>tthanks</p>