TO_DATE function
Converts a string to a date using the specified format string.
Syntax
TO_DATE(expression, format)
Arguments
expression: a
VARCHAR.format: a string made up of format elements.
Returns
A DATE.
Examples
> SELECT TO_DATE('2001-02-03', 'YYYY-MM-DD');
2001-02-03
> SELECT TO_DATE('03 Feb 01', 'DD Mon YY');
2001-02-03