SQL Data Compare - Incorrect Date Format

DN3

Hello,

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

Dan B

Hi DN3,

Thanks for posting on the Redgate forums.

I have raised a bug report for this under internal reference SDC-2485. I will update this forum post with any further information.

Dan B

Hi DN3,

This bug has been resolved in the latest version of SQL Data Compare 12.3. You can download this version here:

ftp://support.red-gate.com/patches/SQLDataCompare/12Apr2017/

davidjrh

Hi, I had a similar issue today, seems the SQL Data Compare is generating the dates in the format 'YYYY-MM-DD HH:mm:ss.nnn', but the required format is 'YYYY-MM-DDTHH:mm:ss.nnn' (note the 'T' separating the date and time). 

Reference: https://social.msdn.microsoft.com/Forums/es-ES/e7262574-aaf0-4705-9a50-40473971c2e5/error-la-conversin-del-tipo-de-datos-varchar-en-datetime-produjo-un-valor-fuera-de-intervalo?forum=sqlserveres