Help Problem in mysql HELP

[Bigman]

i have error in my sql 

i add my back up server and i have this error ... HELP ^^

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NOT NULL,
  `charName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_' at line 2
[Err] CREATE TABLE `l2votes`  (
  `votedate` datetime(0) NOT NULL,
  `charName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  INDEX `votedate_idx`(`votedate`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Edited May 7, 2020 by DukeAwesome

[SweeTs]

Datetime precision is set to 0, drop it.

 

  On 5/3/2020 at 7:41 AM, Bigman said:

`votedate` datetime NOT NULL

Expand