All Products
Search
Document Center

:Date data format changes after data is transferred using the change tracking feature

Last Updated:Jan 16, 2023

Overview

This article describes how to track data in a MySQL database where the data type is Date. After you track data changes, the data format is determined by YYYY-MM-DD the format changes to YYYY:MM:DD the reason.

Description

The default storage format of DTS is YYYY:MM:DD, YYYY-MM-DD is the format of the presentation, the actual storage is YYYY:MM:DD format. Therefore, all the data format written in transmission must be converted to the default format.

Application scope

  • Data Transmission Service (DTS)