MySQL 5.6 DATETIME doesn’t accept milliseconds/microseconds

Found the answer. Data type should be DATETIME(6) for microseconds and DATETIME(3) for milliseconds.

TIME and TIMESTAMP column types also support fractional seconds with the same syntax.

For more information, consult the MySQL Reference on Fractional Seconds.