Create Oracle with DATE type not TIMESTAMP type when no fractional seconds are present

[jason_scarlett]

Oracle (https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT413😞

• DATE = yyyy-mm-dd hh:mm:ss
• TIMESTAMP  = yyyy-mm-dd hh:mm:ss.ssssss (6 decimal seconds .. and timezone?)

Alteryx (https://help.alteryx.com/2018.3/Reference/DataFieldType.htm😞

• DATE = yyyy-mm-dd
• DATETIME  = yyyy-mm-dd hh:mm:ss

In an ideal world the Alteryx DATATIME would map to the Oracle DATE ... and only to the Oracle TIMESTAMP if it had fractional seconds.

Currently DATETIMEs get mapped to Oracle TIMESTAMP.