Incorrect datetime value in MySQL -


server type: mysql server version: 5.7.13-0ubuntu0.16.04.2 - (ubuntu) 

here's how table created:

create table `full_contact_uploads` (   `id` bigint(20) unsigned not null,   `text` varchar(24) collate utf8_unicode_ci default null,   `likelihood` varchar(5) collate utf8_unicode_ci default null,   `type` varchar(24) collate utf8_unicode_ci default null,   `status` varchar(12) collate utf8_unicode_ci default 'active',   `batch` varchar(12) collate utf8_unicode_ci default null,   `requestid` varchar(48) collate utf8_unicode_ci default null,   `created_at` timestamp not null default current_timestamp,   `processed_at` datetime default null ) engine=innodb default charset=utf8 collate=utf8_unicode_ci;   alter table `full_contact_uploads`   add primary key (`id`),   add key `text` (`text`);   alter table `full_contact_uploads`   modify `id` bigint(20) unsigned not null auto_increment;   

however, if this:

update `full_contact_uploads` set `likelihood` = '0.9', `requestid` = '194590cf-6ea9-426d-aa72-9ba25bdb1979', `status` = 'processed', `processed_at` = '09-01-2016 22:21:58' `id` = '2'    

i following error message:

#1292 - incorrect datetime value: '09-01-2016 22:21:58' column 'processed_at' @ row 1 

i believe correct time format. ideas?

mysql always expects date components ordered per iso 8601, i.e. yyyy[-]mm[-]dd


Comments