[jira] [Created] (NIFI-12313) PutDatabaseRecord Insert datetime without microseconds due to data type conversion

["AnibalV (Jira)" <ji...@apache.org>]

AnibalV created NIFI-12313:
------------------------------

             Summary: 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: AnibalV
         Attachments: database.png, flowfile.png, nifi_flow.png

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)