Nifi 1.14 PutDatabaseRecord DateTime Bug: writes using local timezone (adding or removing hours from DateTime column)

GabrielNifi — Mon, 19 Jul 2021 18:17:46 GMT

Flow: QueryDatabaseTable >> PutDatabaseRecord (using the same MS SQL table)

Original Date: '2020-01-01 01:00:00.000'

Saved Date: '2019-12-31 22:00:00.000'

Another:

Original Date: '1753-01-01 00:00:00.000' (SQL Server minimum date)

Saved Date: Routing to failure.: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

My timezone: (GMT-3)

Re: Nifi 1.14 PutDatabaseRecord DateTime Bug: writes using local timezone (adding or removing hours from DateTime column)

GabrielNifi — Mon, 19 Jul 2021 18:37:51 GMT

Solution: Do not use string. "Use Avro Logical Types: TRUE"