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

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

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