title: Incorrect datetime value in MySQL 8 - How to fix?
body: <pre><code>INSERT INTO `projects` (`name`, `created_at`) VALUES ('test', '2015-01-21 04:09:46');
  INSERT INTO `projects` (`name`, `created_at`) VALUES ('test', '2016-03-27 01:29:59');
  </code></pre>
  
  <p>The first query run good, the second given an error: Error in query (1292): Incorrect datetime value: '2016-03-27 01:29:59' for column 'created_at' at row 1</p>
  
  <p>The sql_mode is:</p>
  
  <pre><code>STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
  </code></pre>
  
  <p>The table:</p>
  
  <pre><code>DROP TABLE IF EXISTS `projects`;
  CREATE TABLE `projects` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  </code></pre>
  
  <p>MySQL version: 8.0.19</p>