How to convert a string to date in MySQL?

SELECT  STR_TO_DATE(yourdatefield, '%m/%d/%Y')FROM    yourtable

You can also handle these date strings in WHERE clauses. For example

SELECT whatever  FROM yourtable WHERE STR_TO_DATE(yourdatefield, '%m/%d/%Y') > CURDATE() - INTERVAL 7 DAY

You can handle all kinds of date/time layouts this way. Please refer to the format specifiers for the DATE_FORMAT() function to see what you can put into the second parameter of STR_TO_DATE().

mysql string date

STR_TO_DATE('12/31/2011', '%m/%d/%Y')

mysql string date

SELECT  STR_TO_DATE(StringColumn, '%d-%b-%y')FROM    table

say for example use the below query to get output

SELECT STR_TO_DATE('23-feb-14', '%d-%b-%y') FROM table

For String format use the below link

CodeHunter