Month: May 2018

Dates In SQL Server: DATETIME2 vs SMALLDATETIME

Dates In SQL Server: DATETIME2 vs SMALLDATETIME

While working on the first article about dates Dates In SQL Server: Managing & Manipulating Dates, I touched on the datatypes and realised that it’s worth devoting some time to the subtle but potentially dangerous difference between these two. I previously said: If you need to include time (so not just the whole day) then…

Read More Read More

Dates In SQL Server: Managing & Manipulating Dates

Dates In SQL Server: Managing & Manipulating Dates

Working with dates correctly gives us a lot of power. Dates are a surprisingly complex part of databases, especially if we take into consideration the general complexities in calendars. SQL Server has a lot of subtleties, and some formatting nuances which can be difficult to remember.┬áThis is the first in a short series of articles…

Read More Read More