Actually, the article has been out for about a month now, but I first solicited feedback on errors and typo's and then I forgot to mention the update here... Anyhow, the article now also covers 2008 and the new date, time, datetime2 and datetimeoffset types. There are some interesting aspects of the new types which sets them apart from the old ...

Most of you already know the answer to this question: no. I won't recap the rules for interpretation of the current datetime literals, as I have an article on the subject: http://www.karaszi.com/SQLServer/info_datetime.asp However, SQL Server 2008 introduces a number of new date, datetime and time datatypes. One interesting aspect of these is ...