Converting Datetimes Using TO_CHAR() and TO DATE()
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.