title: Subtract one day from datetime
body: <p>I have a query to fetch date diff between 2 datetime as :</p>
  
  <pre><code>SELECT DATEDIFF(DAY, @CreatedDate , GETDATE())
  
  Ex :
  
  SELECT DATEDIFF(DAY, '2013-03-13 00:00:00.000' , GETDATE())
  </code></pre>
  
  <p>I need to have a query work like this which will subtract a day from created day:</p>
  
  <pre><code>SELECT DATEDIFF(DAY, **@CreatedDate- 1** , GETDATE())
  </code></pre>