title: Invalid default value for 'date' field
body: <blockquote>
    <p>I took a look at this <a href="https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field">possibly dupicated article</a>, but still did not find the result that
    I am looking for. The answer to that question explained <strong>how</strong>
    things work, but did not provide <strong>how to actually solve</strong> this problem.
    There was a solution to MYSQL bench, but I am working with TERMINAL on
    MAC OX.</p>
  </blockquote>
  
  <p><code>birthday date NOT NULL DEFAULT '0000-00-00'</code></p>
  
  <p>Returns: <code>ERROR 1067 (42000): Invalid default value for 'birthday'.</code></p>
  
  <p>How do I fix this problem? Can someone provide the <strong>full syntax?</strong> I am working with terminal on MAC OX. </p>
  
  <p>Your help is much appreciated!</p>