title: STR_TO_DATE() Returning NULL
body: <p>I've looked at the other questions regarding STR_TO_DATE() and their solutions aren't working for my case. I've also read up and searched elsewhere to no avail.</p>
  
  <p>I'm importing many rows of the following XML:</p>
  
  <pre><code>&lt;Game&gt;
    &lt;id&gt;21&lt;/id&gt; 
    &lt;GameTitle&gt;Final Fantasy XIII&lt;/GameTitle&gt; 
    &lt;ReleaseDate&gt;03/09/2010&lt;/ReleaseDate&gt; 
  &lt;/Game&gt;
  
  &lt;Game&gt;
    &lt;id&gt;31&lt;/id&gt; 
    &lt;GameTitle&gt;Heavenly Sword&lt;/GameTitle&gt; 
    &lt;ReleaseDate&gt;09/12/2007&lt;/ReleaseDate&gt; 
  &lt;/Game&gt;
  </code></pre>
  
  <p>With the following SQL statement:</p>
  
  <pre><code>USE test;
  LOAD XML LOCAL INFILE 'C:\\xampp\\mysql\\data\\test.xml'
  REPLACE
  INTO TABLE games
  ROWS IDENTIFIED BY '&lt;Game&gt;'
  SET ReleaseDate = STR_TO_DATE(@ReleaseDate, '%c/%e/%Y');
  </code></pre>
  
  <p>GameTitle and ID are importing perfectly. I've tried using %m and %d and have ensured that the ReleaseDate column is the DATE datatype. All rows are writing NULL in the ReleaseDate column.</p>
  
  <p>MySql is returning </p>
  
  <pre><code>2466 row(s) affected, 64 warning(s): 1265 Data truncated for column 'ReleaseDate' 
  at row 1 1265
  </code></pre>
  
  <p>Thank you in advance for you help. StackOverflow has solved every problem I've really ever had without even having to ask.</p>