title: Incorrect Date Value while loading CSV file to Table
body: <p>I am trying to Populate data into Employee table where B_Date is set to DATE in Mysql. But getting this error - </p>
  
  <blockquote>
    <blockquote>
      <p>Row import failed with error: ("Incorrect date value: '05/06/1985' for column 'B_DATE' at row 1", 1292)</p>
    </blockquote>
  </blockquote>
  
  <p>So How do I change the format into DD-MM-YYYY for a particular table or column?</p>
  
  <p>I have tried this - </p>
  
  <blockquote>
    <p>SELECT DATE_FORMAT(B_DATE, '%d-%m-%y') from employees;</p>
  </blockquote>
  
  <p>still giving same error while loading Data.</p>