Data Compare v - datetime column comparison

Hello Community,

I'm comparing MS SQL 2016 tables and Data Compare (v which shows difference btw source (12:00:00 AM) and target (00:00:00.000) for a column containing timestamp (column type 'datetime' on both source and target)

When comparing manually via SQL Mgmt Studio record is actually the same on source and target:

Question: Is this fixed in later Data Compare versions? I noticed post from few years back having similar issue with date compare: 



  • Hello Ikka,

    Yes, the issue of Datetime formatting was addressed in version
    In the release notes it lists:

    SDC-2485: DateTime data is now formatted consistently in the differences grid.
    Here is a link to the Release Notes (bottom of the page).

    If  your SQL Data Compare license for version 12.2 is still supported, than you should be able to upgrade to version 12.3.
    Please let me know if you have any other questions on this.

    Mac Frierson | Product Support Engineer | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.