Connect Digest : 2009-10-09
This past week I was reviewing a few bugs surrounding the new DATE, TIME, DATETIME2 and DATETIMEOFFSET data types, introduced in SQL Server 2008. While they are much more like first-class citizens than the CLR-based types that Microsoft tried unsuccessfully to introduce with SQL Server 2005, there are still a variety of integration problems that make them very difficult candidates for users to switch from the old standby DATETIME and SMALLDATETIME types. Rather than give my spin on every single one of them, I thought I would just list them here and allow you to discern which ones interest you on title alone, without any of my commentary. Well, at least here; you may see my input on some of these items.