Jim Thomas

I created the exact same table you have in your email response. I cannot 'Make Editable' and change the DateTime2TestStr without an error. Regards, Jim Thomas From: Jim Thomas dreamu@users.sourceforge.net Sent: Saturday, May 9, 2020 5:26 PM To: [squirrel-sql:bugs] 1431@bugs.squirrel-sql.p.re.sourceforge.net Subject: [squirrel-sql:bugs] Re: #1431 Cannot edit row from MS SQL Server which contains DateTime2 Thanks for checking into it! Are you running Compatibility Level 120 or lower? In that case you...

Thanks for checking into it! Are you running Compatibility Level 120 or lower? In that case you will not see the fractional milliseconds. Here is a quote from Microsoft: An example of a breaking change protected by compatibility level is an implicit conversion from datetime to datetime2 data types. Under Database Compatibility Level 130, these show improved accuracy by accounting for the fractional milliseconds, resulting in different converted values. To restore previous conversion behavior, set...

Cannot edit row from MS SQL Server which contains DateTime2