I am continuing putting some common examples of operations for Microsoft SQL Server.
In addition to some of the Date related code snippets published before, there are few more today:
-- Last 90 days: select DATEADD(day, -90, GETDATE()) -- Get Date portion of DateTime value select DATEADD(d, 0, DATEDIFF(d, 0, getdate()))
0 Comments