# The only date in SQL

Pros:

* No varchar<->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()))
    ```