title: Mysql date warning data truncated
body: <p>I'm having an interesting issue with Mysql DATE format.
  I have this table :</p>
  
  <pre><code>| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
  | file_path   | varchar(255) | YES  |     | NULL    |                |
  | date_export | date         | YES  |     | NULL    |                |
  </code></pre>
  
  <p>When i'm updating a row using the date function : NOW(), the date is updated with this format :</p>
  
  <pre><code>'2014-01-23'
  </code></pre>
  
  <p>But when i'm using another date format, like hand-written one like :</p>
  
  <pre><code>update backup_conf_allied set date_export='2014-23-01' where file_path='IDF-952584-SW1' ;
  </code></pre>
  
  <p>The date_export column transforms into :</p>
  
  <pre><code>'0000-00-00'
  </code></pre>
  
  <p>Warning table tells me that :</p>
  
  <pre><code>| Warning | 1265 | Data truncated for column 'date_export' at row 3628 |
  </code></pre>
  
  <p>Why? The date format is the same as NOW() function.
  Thanks.</p>