What are the challenges you face when working across database platforms? Take the survey

SQL Data Compare - Incorrect Date Format

DN3DN3 Posts: 2
edited March 24, 2017 5:17AM in SQL Compare

I am comparing 2 database tables, in different databases on the same server.
Both data tables have a date field formatted as smalldatetime.

However, when I use SQL Data Compare to compare these fields, the results are reporting that one of these dates is in the format dd/mm/yyyy whereas the other date is in the format yyyy-mm-dd.
Therefore SQL Data Compare is reporting these dates as different (even though they aren't)

When viewed through SQL Management studio the dates in both tables appear as yyyy-mm-dd and are identical.

Can you help?
Many Thanks

Best Answers


Sign In or Register to comment.