Comparing a DATETIME field and DATE field

ralindblom

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.

Manfred.Castro

You should have no problem comparing a DATETIME field and DATE field.
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.

ralindblom

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.

Manfred.Castro

You can try using a view to manipulate the data and compare against the view.