DATETIME2 not accurate
BlueBSH
Posts: 25 Bronze 2
I've noticed that DATETIME2 columns are only syncing with a precision of 3 when I have it set to DATETIME2(7) I only get the first 3 of the 7 digits in the SQL scripts SQL Datacompare 11 generates... example is in the database the time value is this
2014-11-13 15:38:59.2837633
but when It generates the script, I get this
2014-11-13 15:38:59.2830000
any ideas why?
2014-11-13 15:38:59.2837633
but when It generates the script, I get this
2014-11-13 15:38:59.2830000
any ideas why?
Comments
Thanks for your post and sorry for the delay in getting back to you!
Can you send me the screenshot of the error along with the detailed version number of SQL Data Compare you are using? (Navigate to help --> About SQL Data Compare in the user-interface)
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com