title: Why does datediff return 1 day less than the actual difference?
body: <p>Consider the following snippet of SQL:</p>
  
  <pre><code>Select DATEDIFF(dd, '2014-09-22 09:14:01.850','2014-09-24 17:14:53.243') -- 1
  </code></pre>
  
  <p>This returns "2", but I actually want "3", since I am calculating the total number of days attended by an employee. I.e. in the above case he has attended <em>3</em> days, but <code>datediff</code> shows 2. Is there any way to get around this?</p>