to_date
Converts "expression1" to a date value as specified by the format "string_expression2". The first argument "expression1" may be of type string or numeric.
Syntax
to_date ( expression1 , string_expression2 )
Example
to_date ( '2013-02-27' , 'YYYY-MM-DD' )
Result
Returns date with value '2013-02-27'.