title: MySQL Server Time Wrong (No Timezone issue!!!)
body: <p>i just noticed that the now() function on one of my MySQL servers is a couple seconds behind the local time. The unix-timestamp seems to work right and the Time of the operating sytem goes right as well.
  The Conversation of the unix timestamp to a formated date does not work.</p>
  
  <p>The following <strong>example request</strong> shows the problem:</p>
  
  <pre><code>select unix_timestamp(), from_unixtime(unix_timestamp()), now();
  </code></pre>
  
  <p><strong>result</strong>:</p>
  
  <pre><code>1422519597, 2015-01-29 09:19:33, 2015-01-29 09:19:33`
  </code></pre>
  
  <p>If u take the timestamp '1422519597' and put it in an unix time converter, u will get '29.1.2015 09:19:57 GMT+1:00' which has a difference of 24 seconds in comparison to the now() and from_unixtime(unix_timestamp()) function .
  The request was made via a remote mysql workbench and via phpmyadmin.</p>
  
  <p>I already checked the global and session timezone which is configured right. But the timezone could not be the problem anyway because the difference here is in seconds and not in hours.</p>
  
  <p>Please tell me what is going on here.</p>
  
  <p>Best Regards.</p>
  
  <p><strong>EDIT</strong></p>
  
  <ul>
  <li>Version of mysql Server is 5.1.41</li>
  </ul>