Nicholas Carenza created NIFI-3430:
--------------------------------------
Summary: PutSQL Errors attempting to coerce date string to
timestamp
Key: NIFI-3430
URL: https://issues.apache.org/jira/browse/NIFI-3430
Project: Apache NiFi
Issue Type: Bug
Components: Core Framework
Reporter: Nicholas Carenza
I am attempting to write a flat json object to my postgresql database using
ConvertJSONToSQL followed by PutSQL. My json has a string date field in ISO
8601 format which postgres can accept as a timestamp. The column in the
database is of type 'timestamp without time zone'.
org.apache.nifi.processor.exception.ProcessException: The value of the
sql.args.33.value is '2017-02-01T23:12:21+00:00', which cannot be converted to
a timestamp
Is PutSQL trying to do some preprocessing here that it should just let the
database handle?
select cast('2017-02-01T23:12:21+00:00' as timestamp without time zone);
timestamp
---------------------
2017-02-01 23:12:21
(1 row)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
