If I use esriFieldTypeDate with ArcGIS 10.2 a DATE column is created in Oracle.
If I use it in ArcGIS 10.6 a TIMESTAMP(6) is used
Is there a way to set DATE as default column type for esriFieldTypeDate?
In 10.4 the supported Oracle data type for esriFieldTypeDate switched to TIMESTAMP. I don't think there is any way around this if the data is created within the ArcGIS Environment.
http://desktop.arcgis.com/en/arcmap/10.4/manage-data/gdbs-in-oracle/data-types-oracle.htm