Jasee Tao created NIFI-5091:
-------------------------------
Summary: nifi CaptureChangeMySQL should consider timezone
Key: NIFI-5091
URL: https://issues.apache.org/jira/browse/NIFI-5091
Project: Apache NiFi
Issue Type: Bug
Reporter: Jasee Tao
MySQL's binlog doesn't log timezone。For example if I have a mysql using
timezone CST(GMT+8)，and insert a create_time '2018-04-18 08:00:00’ (already in
CST)，in the binlog the create_time is '2018-04-18 08:00:00' (without timezone
information)，and in the output of CaptureChangeMySQL the create_time becomes
'2018-04-18 16:00:00 CST'。Perhaps should add a configurable "timezone" property
to identify the binlog's timezone?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
