title: How can I block '0000-00-00 00:00:00' date values from getting into my MySQL table?
body: <p>I'm using MySQL 5.5.37 on OS X 10.9.1. I have a <code>NOT NULL</code> column of type <code>DATETIME</code>.  Without using triggers, how can I block a value of '0000-00-00 00:00:00' from getting into my column? I'll accept a value of CURRENT_TIMESTAMP in place of all the zeroes.</p>
  
  <p>I tried:</p>
  
  <pre><code>SET sql_mode = 'NO_ZERO_DATE';
  </code></pre>
  
  <p>I was still able to insert a zero date into my table after running the above.</p>