Matt Burgess created NIFI-10057:
-----------------------------------
Summary: Support MSSQL's DATETIMEOFFSET type in ExecuteSQL
processors
Key: NIFI-10057
URL: https://issues.apache.org/jira/browse/NIFI-10057
Project: Apache NiFi
Issue Type: Improvement
Components: Extensions
Reporter: Matt Burgess
Currently ExecuteSQL and ExecuteSQLRecord do not support SQL Server's
DATETIMEOFFSET type as it returns a [non-standard
constant|https://docs.oracle.com/javase/8/docs/api/constant-values.html#java.sql.Types.ARRAY]
(-155) for the type. However the driver does return the value as a Timestamp
so it would be nice for NiFi to support the -155 type by handling it as a
timestamp (we do something similar for some of Oracle's custom timestamp types).
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
