title: SQL DATEDIFF Not working?
body: <p>I am running a simple DATEDIFF query but it doesn't seem to calculate the days properly or i'm doing something wrong.</p>
  
  <p>If I run</p>
  
  <pre><code>PRINT DATEDIFF(Day, 2010-01-20, 2010-01-01)
  RETURN 19
  </code></pre>
  
  <p>Which is correct. If i change the month in the first date to Feb (02) I get something strange.</p>
  
  <pre><code>PRINT DATEDIFF(Day, 2010-02-20, 2010-01-01)
  RETURN 20
  </code></pre>
  
  <p>Now shouldn't it be 48 or something?</p>
  
  <p>Can anyone see what i'm doing wrong or is this not the correct function to be using if I want the No of days between these dates?</p>
  
  <p>I've tried taking one date from the other:</p>
  
  <pre><code>PRINT (2010-02-20) - (2010-01-01)
  RETURN -20
  </code></pre>
  
  <p>Any help much appreciated.</p>
  
  <p>Thanks
  J.</p>