[ https://issues.apache.org/jira/browse/NIFI-8749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17407544#comment-17407544 ]
ASF subversion and git services commented on NIFI-8749: ------------------------------------------------------- Commit dfa6592a478669e928870207bcee3987bf480d51 in nifi's branch refs/heads/main from Matt Burgess [ https://gitbox.apache.org/repos/asf?p=nifi.git;h=dfa6592 ] NIFI-8749 Revert "Removed implicit time zone conversion to GMT" This reverts commit 758e1850ed0e4af5063877c7e3a56628e5e7ed78. Signed-off-by: Matthew Burgess <mattyb...@apache.org> > PutDatabaseRecord Insert Datetime Type Time Zone Issue > ------------------------------------------------------ > > Key: NIFI-8749 > URL: https://issues.apache.org/jira/browse/NIFI-8749 > Project: Apache NiFi > Issue Type: Bug > Affects Versions: 1.13.0, 1.14.0, 1.13.2 > Reporter: Billy Lin > Assignee: David Handermann > Priority: Critical > Fix For: 1.15.0 > > Attachments: NIFI-8749.json, cc1.png, cc2.png, cc3.png, cc4.png, > image-2021-07-01-15-17-38-035.png, image-2021-07-30-17-35-58-914.png > > Time Spent: 50m > Remaining Estimate: 0h > > when I query a record from Mysql to get an AVRO Flowfile, then use > PutDatabaseRecord(version 1.13.2) insert to another table (with same table > structure), the data of the 'datetime' type column will change. The original > data of the first table I query from is '2021-06-28 > {color:#FF0000}13{color}:14:20.0'. and the data of the second table which I > insert to becomes '2021-06-28 {color:#FF0000}06{color}:14:20.0'.The gap is > {color:#FF0000}7 hours{color}. > our local timezone is PDT ({color:#FF0000}-7:00{color}). It seems that Nifi > has done some timezone conversion work. But the 'datetime' type in mysql > should have no relation to timezone > > when we use version 1.7.1 ,it works fine. -- This message was sent by Atlassian Jira (v8.3.4#803005)