http://sqlblog.com/blogs/alexander_kuznetsov/archive/tags/datetime/default.aspxTags: datetimeenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/12/08/t-sql-tuesday-001-yesterday-it-worked-today-it-s-not-working.aspxTue, 08 Dec 2009 16:06:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19623Alexander Kuznetsov1http://sqlblog.com/blogs/alexander_kuznetsov/comments/19623.aspxhttp://sqlblog.com/blogs/alexander_kuznetsov/commentrss.aspx?PostID=19623But did it actually work yesterday? If the day is Friday, Noverber 13th, or the 13th day of any other month, and your query blows up for the first time, one place to search for is character strings converted to datetime values. The following script illustrates...(<a href="http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/12/08/t-sql-tuesday-001-yesterday-it-worked-today-it-s-not-working.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=19623" width="1" height="1">datetimeT-SQL Tuesday