MySQL: Convert String to Date

E.g. SELECT STR_TO_DATE('10-12-2012','%d-%m-%Y');

Reference: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_str-to-date