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

There's an issue when performing a query against SQL server where a .NET DateTimeOffset is being compared against a SQL Server datetime2 column. SQL Server does weird things for implicit vs explicit ...

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