title: MySQl DATE Format updating Varchar to date in different format
body: <p>I have some office records. Database is already created and filled with lots of data. I have to create search functionality on it. But the problem is database have date field which is in var char form and is in the form "DD-MM-YYYY" eg :"18-11-2011"
  I want to convert the date column in date format without losing this data. I tried doing it on test table and everything turned to zero. eg: 0000-00-00</p>
  
  <p>What can be done for the same ?</p>