TO_DATE Equivalent in MySQL

Question

I am an Oracle DBA learning to manage MySQL. Whats the equivalent of Oracle TO_DATE function in My SQL.    

Now that oracle acquired My SQL will they make PL/SQL work in My SQL ?

Answer 1

You can use STR_TO_DATE() function  to convert a string to date.

A detailed note is available here.. http://dbaspot.com/mysql-faq/476027-mysql-to_date-equivalent.html

On the second question about PL/SQL working in My SQL, I dont think oracle has announced any plans on that yet.  you may want to propose that as a feature request to Oracle on Metalink / CSP