SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y'); : STR_TO_DATE « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. STR_TO_DATE

mysql>
mysql> SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y');
+---------------------------------------+
| STR_TO_DATE('04/31/2004', '%m/%d/%Y') |
+---------------------------------------+
| 2004-04-31                            |
+---------------------------------------+
1 row in set (0.00 sec)

mysql>