title: MySQL set a default value YEAR type
body: <p>The code below doesn't seem to work. I'm trying to set a default value and a time in the future (taking current year + 6 years). any idea?</p>
  
  <pre><code>ALTER TABLE users CHANGE COLUMN dpicture dpicture YEAR NULL DEFAULT 'YEAR(NOW())+6';
  </code></pre>