title: SQL DML: Incorrect date value (MySQL)
body: <p>I created a table in my database:</p>
  
  <pre><code>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', 'INST') NOT NULL,
      PRIMARY KEY (student_no, academic_year, trimester, or_no)
  );
  </code></pre>
  
  <p>I inserted some values:</p>
  
  <pre><code>INSERT INTO official_receipt(student_no , academic_year, trimester, 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, 'DOWN', 'INST'),
      (201201121, 'AY201314', '1', 029944, 2013-07-23, 'NAME', 8000.00, NULL, 'INST', 'INST'),
      (201201101, 'AY201314', '1', 029941, 2013-05-21, 'NAME', 56650.00, NULL, 'FULL', 'CASH'),
      (201201037, 'AY201314', '1', 029942, 2013-05-21, 'NAME', 56650.00, NULL, 'FULL', 'CASH'),
      (201201142, 'AY201314', '1', 029943, 2013-05-21, 'NAME', 63800.00, NULL, 'FULL', 'CASH');
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <pre><code>Error Code: 1292. Incorrect date value: '1987' for column 'issue_date' at row 1
  </code></pre>
  
  <p>I am quite stumped because I already followed the YYYY-MM-DD format. Any help?</p>