Datetime Types in SQL Server 2005: Lets start with a quick look at the existing date time types in SQL Server. The datetime and smalldatetime, these two types are well known to us, So we wont be spending much time here.   Data Type Representation Accuracy smalldatetime YYYY-MM-DD hh:mm:ss 1 minute datetime YYYY-MM-DD hh:mm:ss[.nnn] 0.00333 [...]

Continue reading about SQL Server 2008 new datetime types, functions and the conversions between them