This should be simple but for some reason I can't find it anywhere... -- View image here ...

SQL server will accept datetime strings in more or less any sensible format for the purposes of comparison.<BR><BR>select * from employee<BR>where hire_date='1993-08-19'<BR><BR>select * from ...

How to reproduce Update any datetime field in a SQL Server database 2008 or above. Expected behaviour No exception should occur. In the above exception message, note the milliseconds format is a 6 ...