You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "adg (Jira)" <ji...@apache.org> on 2021/07/01 03:05:00 UTC
[jira] [Created] (NIFI-8749) PutDatabaseRecord Insert Datetime Type
Time Zone Issue
adg created NIFI-8749:
-------------------------
Summary: 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
Reporter: adg
Fix For: 1.13.2
Attachments: cc1.png, cc2.png, cc3.png, cc4.png
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)