Source MySQL Datetime column is replicated with microseconds

marcosmarxm · March 11, 2022, 5:53pm

Airbyte transform MySQL datetimes and timestamp to ISO 8601 format with micro seconds. This allow Airbyte to apply normalization in a more standard way and keep both times similar to other databases.

github.com

airbytehq/airbyte/blob/744e0d5f1305fe5069ed85a54ee9d1e5e27eab9b/airbyte-integrations/connectors/source-mysql/src/main/java/io/airbyte/integrations/source/mysql/MySqlSourceOperations.java#L74-L77

      
        
            case DECIMAL, DECIMAL_UNSIGNED -> putBigDecimal(json, columnName, resultSet, colIndex);
            case DATE -> putDate(json, columnName, resultSet, colIndex);
            case DATETIME, TIMESTAMP -> putTimestamp(json, columnName, resultSet, colIndex);
            case TIME -> putTime(json, columnName, resultSet, colIndex);

Topic		Replies	Views
Maintain datetime/timestamp datatype in destination (IE Postgres & SQL Server sources) Connector Questions & Issues normalization , data-loading , connectors	1	849	October 25, 2022
MSQL Source SQL Exception Month/Year Connector Questions & Issues data-loading	9	642	October 27, 2022
Datetime field saved as dictionary in S3 parquet Connector Questions & Issues data-loading , connectors	6	1280	October 25, 2022
Issue with datetime and timestamp mapping from MySQL to Snowflake Connector Questions connector , bug , datetime , mysql-connector , snowflake-connector	0	25	June 20, 2024
MS SQL Server: How to keep a Date being a Date Connector Questions & Issues connectors	2	193	March 16, 2023

Source MySQL Datetime column is replicated with microseconds

Related topics