Date function in mysql

There is no to_date() function in mysql, which I always use in oracle.

To get a date from string, you can use DATE()

SELECT DATE('2003-12-31 01:02:03');
       -> '2003-12-31'

To get the current date, use CURDATE() or SYSDATE()