Getdate(), -1 day
<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>