title: mysql - Need to allow '0000-00-00 00:00:00' dates
body: <p>I want zero dates to be allowed in MySQL. I have changed the <code>sql_mode</code> to <code>ALLOW_INVALID_DATES,NO_ENGINE_SUBSTITUTION</code>. </p>
  
  <p>I have changed it in <code>/etc/mysql/my.cnf</code>.</p>
  
  <p>Yet, I when I try to insert data I get the error,</p>
  
  <blockquote>
    <p>Data truncation: Incorrect datetime value: '0000-00-00 00:00:00' </p>
  </blockquote>
  
  <p>The MySQL version is 5.7.18. </p>
  
  <p>Any ideas on this would be of great help.</p>