CHAR_TO_DATE

Converts a string to a date, according to the specified format string.

CHAR_TO_DATE(format,dateString);

For information about date formats, see Date and Time Patterns.