USE `test`; DROP TABLE IF EXISTS `datetimetest`; CREATE TABLE `datetimetest` ( `thedate` datetime DEFAULT NULL, `id` varchar(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into `datetimetest`(`thedate`,`id`) values ('2018-01-31 00:00:00','1'); DROP TABLE IF EXISTS `joindatetime`; CREATE TABLE `joindatetime` ( `thedate` datetime DEFAULT NULL, `id` varchar(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into `joindatetime`(`thedate`,`id`) values ('2018-01-31 00:00:00','1');