FLOAT
, DECIMAL
) types, you don't need to specify scale and precision.DATE
, TIME
, DATETIME
and TIMESTAMP
support ISO formats only. Also, you will experience precision loss if your data has times and timestamps that go beyond 6 fractional digits (millisecond precision).