title: Data truncation: Truncated incorrect date value error
body: <p>I'm using MySQL version: 5.7.22</p>
  
  <p>So I'm trying to have a table that contains a date column from string. The text field contains data in following DateTime format <code>"d/m/YYYY h:m:s"</code> format. e.g. <code>"14/11/2018 20:10:04 +00:00"</code>.</p>
  
  <p>I want to alter the table with a new column that is of the following format <code>'%Y-%m-%d'</code>. I get a</p>
  
  <blockquote>
    <p>Data truncation: Truncated incorrect date value error </p>
  </blockquote>
  
  <p>when I try to update the table. But I get the result when I just use a select statement to convert from string to date.</p>
  
  <pre><code>UPDATE BIG_DATA SET BIG_DATA.RealDate = ( SELECT x.d
                                            From (SELECT (DATE_FORMAT(STR_TO_DATE(BIG_DATA.Date , '%d/%m/%Y'), '%Y-%m-%d')) as d
                                            FROM BIG_DATA) as x);
  </code></pre>
  
  <p>Any help would be grateful! </p>