title: Setting default value for DATE type column to current date without time part?
body: <p><strong>NOTE: The question is about DATE type, not Datetime nor Timestamp</strong></p>
  <p>How to alter column of date data type to use current date by default?
  I saw a lot of examples for <code>datetime</code> (with time part), but not for date. I have tried:</p>
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE `accounting` ALTER `accounting_date` 
    SET DEFAULT CURRENT_DATE;
  ALTER TABLE `accounting` CHANGE `accounting_date` 
    `accounting_date` DATE NOT NULL DEFAULT CURRENT_DATE;
  </code></pre>
  <p>I also tried with <code>CURDATE()</code>, <code>NOW()</code>, <code>CURRENT_DATE()</code> ...</p>