title: how to keep the datetime format from csv to mysql database when importing data?
body: <p>I have a csv file where I changed the initial datetime format:</p>
  
  <ul>
  <li>from <code>m/d/yyyy h:mm (6/15/2011  5:26:00 PM)</code> </li>
  <li>to   <code>yyyy-dd-mm h:mm (2011-15-06 17:26)</code></li>
  </ul>
  
  <p>This was done in order to avoid <code>0000-00-00</code> as datetime value in MySQL database when importing data from that csv to MySQL. </p>
  
  <p>This did not fix the problem. I still found <code>0000-00-00</code> as datetime value in my database.  </p>
  
  <p>To fix the problem, I first created the database in mysql (before importing the data from the csv file),  and I used Datetime type in order to keep the values of date and time from that csv file. </p>
  
  <p>Did I forget something? or is there any better way to fix that problem?</p>