title: How to subtract hours from a datetime in MySQL?
body: <p>I get a datetime field, that's currently in the query as:</p>
  
  <pre><code>SELECT DATE_FORMAT(x.date_entered, '%Y-%m-%d') AS date FROM x ORDER BY date ASC
  </code></pre>
  
  <p>What I want to do is to subtract 3 hours from that date (GMT issues), but I can't do it in PHP as PHP only knows the date part, not the time.</p>