Debezium MySQL Source Connector datatime type column transform problem - Githubissues

apache / rocketmq-connect

A tool for scalable and reliably streaming data between Apache RocketMQ and other systems.

https://rocketmq.apache.org/

Apache License 2.0

122 stars 118 forks source link

Debezium MySQL Source Connector datatime type column transform problem #202

Open odbozhou opened 2 years ago

odbozhou commented 2 years ago

BUG REPORT

Please describe the issue you observed:

When the time zone is Shanghai, the time sent to RocketMQ will be 16 hours less than the time in the database

What did you do (The steps to reproduce)?
What is expected to see?
What did you see instead?

Please tell us about your environment:
Other information (e.g. detailed explanation, logs, related issues, suggestions on how to fix, etc):

FEATURE REQUEST

Please describe the feature you are requesting.
Provide any additional detail on your proposed use case for this feature.
Indicate the importance of this issue to you (blocker, must-have, should-have, nice-to-have). Are you currently using any workarounds to address this issue?
If there are some sub-tasks involved, use -[] for each sub-task and create a corresponding issue to map to the sub-task:

sub-task1-issue-number: sub-task1 description here,
sub-task2-issue-number: sub-task2 description here,
...

sunxiaojian commented 2 years ago

"database.serverTimezone":"UTC",