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
Post a Comment