Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

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.