to_date

Returns "string_expression1" as a date according to the date format you specify in "string_expression2". If "string_expression1" is NULL, then a NULL value is returned.

to_date ( string_expression1 , string_expression2 )