Starting from SQL Server 2016, the conversion / comparison process of datetime to datetime2 (and vice versa) has been modfied. Unfortunately, this is a breaking change for many of our existing ...

Element ranges YYYY is a four-digit number, ranging from 0001 through 9999, that represents a year. MM is a two-digit number, ranging from 01 to 12, that represents a month in the specified year. DD ...

My favourite fact about storing dates and times in SQL Server is that DATETIME2 (3) uses 7 bytes instead of the 8 bytes DATETIME uses, and has millisecond accuracy versus the 3-ms accuracy of DATETIME ...