DATETIME2 not accurate

BlueBSHBlueBSH Posts: 25 Bronze 2
edited September 15, 2015 6:58AM in SQL Data Compare 11
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?

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Hi,

    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)
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.