title: Date formatting - DD-MM-YYYY to YYYY-MM-DD
body: <p>MySQL table has 2 columns - startdate and enddate</p>
  
  <p>They hold dates in this format: 22-01-2016</p>
  
  <p>When I was prototyping, I used MediumText.</p>
  
  <p>Now, I want to switch to Date format. The default date format in PHPMyAdmin is YYYY-MM-DD</p>
  
  <p>If I switch the columns to Date, my data turns into 0000-00-00.</p>
  
  <p>Using PHP or MySQL, how do I reformat my data prior to going back into PHPMyAdmin to switch the columns to Date format?</p>