Comments
3 comments
-
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. -
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/
-
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
Add comment
Please sign in to leave a comment.
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