For a complete discussion see this thread:
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=171688#bm171793
Also check out this article for lots of info on dates and date comparisons:
http://www.karaszi.com/SQLServer/info_datetime.asp