SQL Data Types Oracle PLSQL Tutorial

TO_CHAR() and TO_DATE() Conversion Functions
FunctionDescription
TO_CHAR(x [, format])Converts the number or datetime x to a string. You can also supply an optional format for x.
TO_DATE(x [, format])Converts the string x to a DATE.