Pros:
<ul>
<li>No varchar&lt;-&gt;datetime conversions required
</li>
<li>No need to think about the locale
</li>
<li><pre><code class="lang-sql"> -- 2 day ago
 SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(DAY, - 2, GETDATE())))
 -- today
 SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
</code></pre>
</li>
</ul>

Pros:

* No varchar&lt;-&gt;datetime conversions required
    
* No need to think about the locale
    
* ```sql
    -- 2 day ago
    SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(DAY, - 2, GETDATE())))
    -- today
    SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
    ```

A developer's diary

A developer's diary

The only date in SQL