title: How to convert date in .csv file into SQL format before mass insertion
body: <p>I have a csv file with a couple thousand game dates in it, but they are all in the MM/DD/YYYY format</p>
  
  <pre><code>2/27/2011,3:05 PM,26,14
  </code></pre>
  
  <p>(26 and 14 are team id #s), and trying to put them into SQL like that just results in 0000-00-00 being put into the date field of my table. This is the command I tried using:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'c:/scheduletest.csv' INTO TABLE game
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  (`date`, `time`, `awayteam_id`, `hometeam_id`);
  </code></pre>
  
  <p>but again, it wouldn't do the dates right. Is there a way I can have it convert the date as it tries to insert it? I found another SO <a href="https://stackoverflow.com/questions/5616494/how-to-convert-csv-date-format-to-into-mysql-db">question</a> similar to this, but I couldn't get it to work.</p>