Matt Burgess created NIFI-7208: ---------------------------------- Summary: PutSQL doesn't handle nanoseconds Key: NIFI-7208 URL: https://issues.apache.org/jira/browse/NIFI-7208 Project: Apache NiFi Issue Type: Bug Components: Extensions Reporter: Matt Burgess
According to the documentation PutSQL should be able to manage nanoseconds: https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.9.0/org.apache.nifi.processors.standard.PutSQL/ ".]sql.args.N.format [...] as specified according to java.time.format.DateTimeFormatter" DateTimeFormatter should be able to manage nanoseconds. The issue seems to be happening in JdbcCommon.java Line 840-843: final DateTimeFormatter dtFormatter = getDateTimeFormatter(valueFormat); TemporalAccessor accessor = dtFormatter.parse(parameterValue); java.util.Date parsedDate = java.util.Date.from(Instant.from(accessor)); lTimestamp = parsedDate.getTime(); It seems to be truncated on line 842 java.util.Date parsedDate = java.util.Date.from(Instant.from(accessor)); as java.util.Date doesn't handle nanoseconds. A Java time construct that can handle nanoseconds should be used instead of Date. -- This message was sent by Atlassian Jira (v8.3.4#803005)