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 ...

As Insight.Database maps C# DateTime type to DbType.DateTime, using SQL types Date or DateTime is not authorized if the date is not in the DateTime range (1/1/1753 - 12/31/9999). C# DateTime (or ...