The following code will convert the string into a datetime datatype. STR_TO_DATE(datestring, '%m/%d/%Y') To change the format of the date displayed, use DATE_FORMAT. DATE_FORMAT(STR_TO_DATE(datestring, '%m/%d/%Y'), '%Y-%m-%d')