title: How to remove NO_ZERO_DATE from sql_mode in mysql?
body: <p>I need to remove <code>NO_ZERO_DATE</code> globally from <code>sql_mode</code>.</p>
  
  <p>Is it possible to retain any default values while removing it?</p>
  
  <p>Something like pseudocode:
  <code>my.cnf</code>:</p>
  
  <pre><code>sql_mode = $sql_mode(regex.replace(NO_ZERO_DATE, '');
  </code></pre>
  
  <p>Advantage would be that I would not override the defaults of defaults chance in future versions of <code>mysql</code>.</p>