Details
-
Feature Request
-
Resolution: Unresolved
-
Minor
-
None
-
None
-
False
-
None
-
False
-
0
-
0%
Description
Hello, is there any possible to output time string more than UTC, because when I get the captured data from mysql, the column in timestamp type has the T&Z in it like ##2022-06-06T14:49:26Z##, and when I insert the data to another mysql server (the version is (5.7.36-log)with same table schema, the error is show like ##ERROR 1292 (22007): Incorrect datetime value: '2022-06-07T16:16:45Z' for column 'update_time' at row 1##.
I think the error because mysql can't accept the UTC data as timestamp,
so I wander if it's possible to allow user to set the output timestamp format?
thanks a lot
Bug report
For bug reports, provide this information, please:
What Debezium connector do you use and what version?
I use the version <1.5.4>, but I check the latest code in ##/debezium-core/src/main/java/io/debezium/time/ZonedTimestamp.java##, there is not change