You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Jasee Tao (JIRA)" <ji...@apache.org> on 2018/04/18 07:22:00 UTC

[jira] [Created] (NIFI-5091) nifi CaptureChangeMySQL should consider timezone

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)