title: Excel dates cannot be converted to desired format
body: <p>I am trying to import data from a .csv file into MySQL using:</p>
  <pre><code>LOAD DATA LOW_PRIORITY LOCAL INFILE 'file_path_here' 
  REPLACE INTO TABLE `pitch_data` 
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES
  (id,AT_BAT_NUMBER,etc.,...,ZONE)
  SET GAME_DATE = STR_TO_DATE(@GAME_DATE, '%m/%d/%Y')
  ;
  </code></pre>
  <p>but the conversion of GAME_DATE from MM/DD/YYYY (in the .csv file) to the required format, YYYY-MM-DD isn't happening (I'm receiving the &quot;Error Code: 1292. Incorrect date value: '10/30/2019' for column 'GAME_DATE' at row 1&quot; message).</p>
  <p>I have tried changing the format of the GAME_DATE column manually in an .xlsx file to save and copy to the .csv file, but even in the .xlsx file I can't change the format.  Strangely, when I select the &quot;Format Cells&quot; option, it indicates that the data are already in the format, YYYY-MM-DD, but they appear as MM/DD/YYYY to the eye.  I have tried a similar approach with the &quot;Text to Columns&quot; wizard, but no luck.</p>
  <p>Any help would be appreciated!</p>
  <p>added code from comment:</p>
  <p>Certainly. Here is a subset of the .csv:</p>
  <pre><code>id AT_BAT_NUMBER GAME_DATE 
  1  79            10/30/2019 
  2  79            10/30/2019
  </code></pre>
  <p>and the SQL code:</p>
  <pre><code>LOAD DATA LOW_PRIORITY LOCAL INFILE 'FILE_PATH_TO_CSV' 
  REPLACE INTO 
  TABLE pitch_data 
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\r\n' 
  IGNORE 1 LINES 
  (id,AT_BAT_NUMBER,GAME_DATE) 
  SET GAME_DATE = STR_TO_DATE(@GAME_DATE, '%m/%d/%Y') 
  </code></pre>