[
https://issues.apache.org/jira/browse/NIFI-8749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17407640#comment-17407640
]
ASF subversion and git services commented on NIFI-8749:
-------------------------------------------------------
Commit 20804ff2b1d8258cdd9f37f81b5dee4fd67feb57 in nifi's branch
refs/heads/main from David Handermann
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=20804ff ]
NIFI-8749 Removed implicit time zone conversion to GMT
- Updated DataTypeUtils.getDateFormat() to use system default time zone
- Updated Record Path Guide to match Expression Language Guide regarding
default time zone
- Updated impacted unit tests to expect localized dates instead of dates
converted to GMT
NIFI-8749 Set user.timezone in TestRecordPath to avoid unexpected date
conversions
Signed-off-by: Matthew Burgess <mattyb...@apache.org>
This closes #5361
> 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: 1.5h
> 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)
