• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Modify comparison of date and time values

While comparing date and time values you should take into account the points: different time zones and preferred time accuracy (up to days or milliseconds). Here’s how you can manage the options for date and time data types correctly and avoid problems in data comparison.

  1. In the data options section, you can specify options for the date and time data types:

  2. Select the Comparison mode from the drop-down list. Here are the options you can specify:

    • Full – the Database Compare Suite application will compare all date and time values without modifications;

    • Do not compare – the Database Compare Suite application will not compare all date and time values;

    • Ignore time – the Database Compare Suite application will ignore time in comparison, and will compare only date;

    • Ignore milliseconds – the Database Compare Suite application will ignore milliseconds in all time values before comparison.

    • Here are the examples of using different values for the Comparison mode option. Let’s compare the values “2/15/2016 13:45:30.61” and “2/15/2016 13:45:30.6175”:

      Comparison mode Value 1 Value 2 Result
      Full 2/15/2016 13:45:30.61 2/15/2016 13:45:30.6175 Not equal
      Do not compare 2/15/2016 13:45:30.61 2/15/2016 13:45:30.6175 Not comparing
      Ignore time 2/15/2016 2/15/2016 Equal
      Ignore milliseconds 2/15/2016 13:45:30 2/15/2016 13:45:30 Equal
  3. Check the Ignore time zone option to ignore time zone information during data comparison operation. If the checkbox is unchecked, the data comparison operation will consider time zone information.

    Here are the examples of using different values for the Ignore time zone option. Let’s compare the values “2/15/2016 13:45:30.0055 +03:00” and “2/15/2016 13:45:30.0055 +07:00”:

    Ignore time zone Result
    Unchecked Not equal
    Checked Equal
  4. Click the Reset button to restore default parameters for all modified options.

  5. Please note that the operation properties are stored by the application for the entire project, so all changes to the operation settings that you have made will be automatically used for all objects of the same type in your project.