无效的日期时间格式:1292错误的日期时间值-Laravel 5.2 [英] Invalid datetime format: 1292 Incorrect datetime value - Laravel 5.2

问题描述

将这些值插入数据库表时出现此错误:

I'm getting this error when I insert these value into my database table:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value:
'24/06/2017' for column 'registration_from' at row 1 
(SQL: insert into `campus_registrations` (`campus_major_class_id`, 
`registration_from`, `registration_to`, `testing`, `announcement`, 
`enrollment_from`, `enrollment_to`, `updated_at`, `created_at`) values (3, 
24/06/2017, 27/06/2017, 13/07/2017, 01/08/2017, 05/09/2017, 31/01/2018,
 2017-06-07 09:39:31, 2017-06-07 09:39:31))

我必须先启动日期时间还是什么?

Do I have to intiate the datetime first or what?

推荐答案

错误在这里:

Incorrect datetime value: '24/06/2017' for column 'registration_from' at row 1

mysql中date列的默认格式为Y-m-d，datetime的默认格式为Y-m-d H:i:s.因此，将日期更改为这种格式，然后重试.

the default format for date column in mysql is Y-m-d and for datetime is Y-m-d H:i:s. So change your date to this format and try again.

这篇关于无效的日期时间格式:1292错误的日期时间值-Laravel 5.2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！