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