Database time zone：

Table Structure：

CREATE TABLE time_field_test (
id int(11) NOT NULL AUTO_INCREMENT,
date_column date DEFAULT '2020-01-01',
year_column year(4) DEFAULT '2020',
time_column time DEFAULT '00:00:00',
datetime_column datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
timestamp_column timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

Insert data：
INSERT INTO time_field_test (date_column, year_column, time_column, datetime_column, timestamp_column, created_at, updated_at)
VALUES('2023-01-01', '2023', '17:00:00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

connector configuration：
"transforms.convertTimezone.exclude.fields":"source:time_field_test:datetime_column,source:time_field_test:timestamp_column,source:time_field_test:created_at,source:time_field_test:updated_at"

converted value：
"after":

{ "id":14, "date_column":19358, "year_column":2023, "time_column":61200000000, "datetime_column":1698455907000, "timestamp_column":"2023-10-28T17:18:27+08:00", "created_at":"2023-10-28T17:18:27+08:00", "updated_at":"2023-10-28T17:18:27+08:00" }

Question 1: 2023-10-28T17:18:27+08:00, the converted value is +08:00. Is this reasonable?

Is it possible to keep the same time zone settings as before, like this 2023-10-28T17:18:27?

 

Question 2:
The corresponding value of datetime_column is 1698455907000. The actual insertion time is 2023-10-28T17:18:27.The actual value is 2023-10-28 09:18:27, without adding 8 hours. Is this normal?

Please guide, thank you