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.