-M, --drop-milliseconds

Truncates milliseconds and loads TIME and UTCTIME columns as ansitime columns.

Syntax

-M
--drop-milliseconds

Description

Truncate milliseconds in columns with the data type TIME or UTCTIME and load them as ansitime columns. By default, TIME amd UTCTIME are loaded as ansidatetime columns with a fixed date of January 1, 2035.