title: Is timestampdiff() in MySQL equivalent to datediff() in SQL Server?
body: <p>I am working on migrating functions from SQL Server 2000 to MySQL.</p>
  
  <p>The following statement executed in SQL Server 2000, gives the output as 109.</p>
  
  <pre><code>SELECT DATEDIFF(wk,'2012-09-01','2014-10-01') AS NoOfWeekends1
  </code></pre>
  
  <p>The equivalent query of in mysql uses <code>timestampdiff()</code> instead of <code>datediff</code> and gives the output as 108.  </p>
  
  <pre><code>SELECT TIMESTAMPDIFF(WEEK, '2012-09-01', '2014-10-01') AS NoOfWeekends1
  </code></pre>
  
  <p>I need the output to match when executed in MySQL, so it returns 109.</p>