DateTime format in SQL Server is a bit tricky. Default type for DateTime fields is datetime in SQL Server but you should now that this data type is neither ANSI nor ISO8601 compliant.

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 ...

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 ...