Incorrect datetime value: '1/1/0001 12:00:00 AM' for column 'call_time' at row 1 in Mysql -
i have column named call_time in table of datatype datetime in mysql.now trying insert 1/1/0001 12:00:00 am in call_time colum is giving following error..
incorrect datetime value: '1/1/0001 12:00:00 am' column 'call_time' @ row 1 here complete query string ..
insert outcall values('0117','509','02240576000','','1/1/0001 12:00:00 am','07:1','7') please me ..
to insert dates , times, have use iso date format:
insert outcall values('0117','509','02240576000','','0001-01-01 00:00:00','07:1','7') if want use format, use str_to_date function:
str_to_date("1/1/0001 12:00:00 am", "%c/%e/%y %r")
Comments
Post a Comment