MySQL String operations STR_TO_DATE - Convert string to date
Example
With a column of one of the string types, named my_date_field with a value such as [the string] 07/25/2016, the following statement demonstrates the use of the STR_TO_DATE function:
SELECT STR_TO_DATE(my_date_field, '%m/%d/%Y') FROM my_table;
You could use this function as part of WHERE clause as well.
