title: query sql convert text field dd/mm/yyyy to date field yyyy-mm-dd
body: <p>I've imported a CSV file into mysql with dates in format <code>dd/mm/yyyy</code>.</p>
  <p>I now need a query to convert it from text to date format <code>yyy-mm-dd</code>.</p>