title: UNIX timestamp on MySQL and MSSQL Server
body: <p>How come there is a difference on timestamps in mysql and MS SQL Server<br>
  MySQL: </p>
  
  <pre><code>select now() result: 2013-07-16 08:49:26.0
  </code></pre>
  
  <p>SQL Server:</p>
  
  <pre><code>select getdate() result: 2013-07-16 08:48:16.47
  </code></pre>
  
  <p>and when I try to get <code>unix_timestamp</code><br>
  MySQL: </p>
  
  <pre><code>SELECT UNIX_TIMESTAMP('2013-07-01') result: 1372629600
  </code></pre>
  
  <p>SQL Server:</p>
  
  <pre><code>SELECT DATEDIFF(SECOND,'1970-01-01', '2013-07-01') result 1372636800
  </code></pre>
  
  <p><strong>problem:</strong> there is a difference of 7200 seconds (2h) <br>
  Is this a Time Zone problem, server time on both servers are the same as seen on <code>now()</code> and <code>getdate()</code>?</p>