Database Compare Suite™
- Overview
- Product features
- Getting started
- Connecting to server
- Connecting to an Amazon DynamoDB database
- Connecting to an Amazon Redshift database
- Connecting to an Apache Cassandra database
- Connecting to an Azure SQL Database
- Connecting to an Azure Synapse Analytics data warehouse
- Connecting to a BigQuery data warehouse
- Connecting to a Greenplum database
- Connecting to an IBM DB2 database
- Connecting to an IBM Netezza database
- Connecting to a MariaDB database
- Connecting to a Microsoft Access database
- Connecting to a Microsoft SQL Server database
- Connecting to a MySQL database
- Connecting to an Oracle database
- Connecting to a PostgreSQL database
- Connecting to a Snowflake database
- Connecting to a Sybase ASE database
- Connecting to a Sybase IQ database
- Connecting to a Teradata database
- Connecting to a Vertica database
- Installing the required database drivers
- Creating a new project
- Opening an existing project
- Key activation
- User interface elements
- Connecting to server
- Operations in details
- Schema comparison
- Schema synchronization
- Schema operations options
- Data comparison
- Detailed data comparison
- Fast data comparison
- Data synchronization
- Data migration
- Settings comparison
- Virtual views
- Sorting key selection
- Selecting operation scope
- Matching
- Matching rules
- Fast data comparison options
- Data operations options
- Command-line interface
- Settings
- Requirements
- Known issues
- Support
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.
In the data options section, you can specify options for the date and time data types:
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.
Check the Use tolerance option if you need to specify the allowed difference between two date and time values to treat them as equal. Please note that the minimal supported value for this operation is 1 second and the maximal supported value for this operation is 23 hours 59 minutes 59 seconds.
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
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 Click the Reset button
to restore default parameters for all modified options.
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.
Didn’t find the answer?
You can report problems, ask questions or share ideas for improvements on our email [email protected].