title: Getdate(), -1 day
body: <p>I do not understand why, but somehow this query doesn't work.
  I want to take system date -1 day where the sysdate is smaller by 1 day then current date.</p>
  
  <pre><code>WHERE
      a.SEND_Date &gt;= dateadd(DD,-1,(CAST(getdate() as date) as datetime)) 
  </code></pre>