[
https://issues.apache.org/jira/browse/NIFI-12313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess reassigned NIFI-12313:
-----------------------------------
Assignee: (was: Matt Burgess)
> PutDatabaseRecord Insert datetime without microseconds due to data type
> conversion
> ----------------------------------------------------------------------------------
>
> Key: NIFI-12313
> URL: https://issues.apache.org/jira/browse/NIFI-12313
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.23.2
> Environment: Nifi 1.23.2.
> SQL Server 2022
> Reporter: Anibal Vasquez
> Priority: Major
> Attachments: database.png, flowfile.png, nifi_flow.png
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> We have encountered an issue when migrating from version 1.12.1 to version
> 1.23.2, which is related to the change associated with this issue:
> "[NIFI-8223] - PutDatabaseRecord should use table column datatype instead of
> field datatype."
> This issue introduced a change in the data transformation logic in the
> PutDatabaseRecord processor, which converts a field (e.g., of type string) to
> the data type of its corresponding database column.
> This is causing problems because our field in the database is of type
> datetime2 and our string is "2023-10-19 14:14:59.999314" However, the
> processor is converting it to "2023-10-19 14:14:59" without microseconds,
> despite setting the format in the csvreader.
> To address this, we have made an adjustment in the PutDatabaseRecord
> processor so that users at the processor level can choose whether to apply
> the transformation to the database column type or maintain the Nifi format.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
