title: mysql UNIX_TIMESTAMP returns incorrect value
body: <p>I have the following date in mysql stored in DATETIME field:</p>
  
  <pre><code>2012-04-16 16:21:54
  </code></pre>
  
  <p>Than I select it like this:</p>
  
  <pre><code>SELECT UNIX_TIMESTAMP(date) ....
  </code></pre>
  
  <p>but if I print the hour using php date function I get one hour difference:</p>
  
  <pre><code>echo date("H:i:s", $row-&gt;date)
  </code></pre>
  
  <p>would print:</p>
  
  <pre><code>17:21:54
  </code></pre>
  
  <p>Without the second parameter, the date function returns correct value. Any ideas?</p>