Support Questions
Find answers, ask questions, and share your expertise

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

Explorer

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)

 

1 ACCEPTED SOLUTION

Explorer

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

 

GabrielNifi_0-1626719914848.png

 

View solution in original post

1 REPLY 1

Explorer

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

 

GabrielNifi_0-1626719914848.png

 

; ;