Comparing a DATETIME field and DATE field

• 
  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.

  Manfred.Castro August 31, 2012 13:46

  - 0 +
• 
  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.

  ralindblom August 31, 2012 13:54

  - 0 +
• 
  You can try using a view to manipulate the data and compare against the view.

  Manfred.Castro August 31, 2012 14:52

  - 0 +

Add comment

Please sign in to leave a comment.