kafka输出中关于 datetime timestamp 和时区的问题

[c0494133d4]

kafka输出中关于 datetime timestamp 和时区的问题

[c0494133d4]

MySQL行为

MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such as DATETIME.)

对于date和datetime, 不按@@time_zone进行转换, select结果都是insert时的字面日期时间.

debezium行为

The DATETIME type represents a local date and time such as "2018-01-13 09:48:27". As you can see, there is no time zone information. Such columns are converted into epoch milliseconds or microseconds based on the column’s precision by using UTC. The TIMESTAMP type represents a timestamp without time zone information. It is converted by MySQL from the server (or session’s) current time zone into UTC when writing and from UTC into the server (or session’s) current time zone when reading back the value. For example:

已知dtle kafka输出和dbz一致.