Convert string to date in mysql
Mysql provides an easy to use function to convert string to date/datetime
STR_TO_DATE(string, format)
Example
SELECT STR_TO_DATE('01/12/2012', '%d/%m/%Y')
Output
2012-12-01
Mysql provides an easy to use function to convert string to date/datetime
STR_TO_DATE(string, format)
Example
SELECT STR_TO_DATE('01/12/2012', '%d/%m/%Y')
Output
2012-12-01