SQL DML：日期值不正确(MySQL)_mysql

概述我在我的数据库中创建了一个表：CREATE TABLE official_receipt( student_no INT UNSIGNED, academic_year CHAR(8), trimester ENUM('1', '2', '3'), or_no MEDIUMINT UNSIGNED, issue_dat

我在我的数据库中创建了一个表：

CREATE table official_receipt(    student_no INT UNSIGNED,academic_year CHAR(8),trimester ENUM('1','2','3'),or_no MEDIUMINT UNSIGNED,issue_date DATE NOT NulL,received_from VARCHAR(255) NOT NulL,amount_of DECIMAL(8,2) NOT NulL,issued_by VARCHAR(255),doc_type ENUM('FulL','DOWN','INST') NOT NulL,form_of_payment ENUM('CASH',PRIMARY KEY (student_no,academic_year,trimester,or_no));

我插入了一些值：

INSERT INTO official_receipt(student_no,or_no,issue_date,received_from,amount_of,issued_by,doc_type,form_of_payment)VALUES    (201201121,'AY201314','1',029940,2013-05-21,'name',20000.00,NulL,'INST'),(201201121,029944,2013-07-23,8000.00,'INST',(201201101,029941,56650.00,'FulL','CASH'),(201201037,029942,(201201142,029943,63800.00,'CASH');

我收到此错误：

Error Code: 1292. Incorrect date value: '1987' for column 'issue_date' at row 1

我很难过,因为我已经遵循了YYYY-MM-DD格式.有帮助吗？最佳答案如Date and Time Literals所述：

MysqL recognizes 07001 values in these formats:
As a string in either 'YYYY-MM-DD' or 'YY-MM-DD' format. A “relaxed” Syntax is permitted: Any punctuation character may be used as the delimiter between date parts. For example,'2012-12-31','2012/12/31','2012^12^31',and '2012@12@31' are equivalent.
As a string with no delimiters in either 'YYYYMMDD' or 'YYMMDD' format,provIDed that the string makes sense as a date. For example,'20070523' and '070523' are interpreted as '2007-05-23',but '071332' is illegal (it has nonsensical month and day parts) and becomes '0000-00-00'.
As a number in either YYYYMMDD or YYMMDD format,provIDed that the number makes sense as a date. For example,19830905 and 830905 are interpreted as '1983-09-05'.