title: SQL Server : DATEDIFF Start and End date
body: <p>I get a positive value of <code>100</code> for the following query. Why is it? I was expecting <code>-100</code>.  </p>
  
  <pre><code>SELECT DATEDIFF(SECOND, GETUTCDATE(), DATEADD(SECOND, 100, GETUTCDATE()))
  </code></pre>
  
  <p>From the documentation <a href="https://msdn.microsoft.com/en-us/library/ms189794(v=sql.110).aspx" rel="nofollow">here</a> in MSDN, the format of <code>DATEDIFF</code> function is below  </p>
  
  <pre><code>DATEDIFF (datepart, startdate, enddate)
  </code></pre>
  
  <p>So, I am not sure what am I missing.</p>