Date and Time are showing differences when comparing SQL 2016 datatable with SQL 2008 R2
Time Date Field shows difference due to different formatting - Not easy to work out whether the source and target are identical. Seems like all rows are highlighted.
1
vote
Andrew
shared this idea
Hi there – this sounds like SDC-2485 (Datetime format in results pane is not consistent) which we think we’ve released a fix for in SQL Data Compare 12.3.0.4373 . Could you check out that version and verify if it does what you expect?