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

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 has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...