You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Pierre Villard (Jira)" <ji...@apache.org> on 2026/01/05 10:36:07 UTC
[jira] [Resolved] (NIFI-12313) PutDatabaseRecord Insert datetime without microseconds due to data type conversion
[ https://issues.apache.org/jira/browse/NIFI-12313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pierre Villard resolved NIFI-12313.
-----------------------------------
Resolution: Feedback Received
Apache NiFi 1.x is no longer maintained and no new release is planned on the 1.x release line. Marking as resolved as part of a cleanup operation. Please open a new one with an updated description if this is still relevant for NiFi 2.x.
> 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: 1h
> 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)