Skip to main content

Command Palette

Search for a command to run...

The only date in SQL

Updated
1 min read
The only date in SQL

Pros:

  • No varchar<->datetime conversions required

  • No need to think about the locale

  •   -- 2 day ago
      SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(DAY, - 2, GETDATE())))
      -- today
      SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
    

More from this blog

A developer's diary

45 posts

Just developer