Is there any way of comparing a DATETIME field and DATE field? The time field has 00:00:00.000 so I really am just looking to compare the date portion of both fields.
While the compare happens every items comes back as a difference. I would like to have a date such as 2012-12-31 be shown to equal 2012-12-31 00:00:00.000. Currently they show up as mismatches.
Comments
http://www.red-gate.com/supportcenter/Content/SQL_Data_Compare/help/10.0/SDC_Which_Data_Types_Can_Be_Compared
You can try to set up a view in the source DB and compare to that instead, so there's more control over how the info is presented.
Product Support
Red Gate Software
Product Support
Red Gate Software