Home Oracle Commands Oracle Syntax
Oracle : to_char

Convert an expression to a character String

to_char(expression[,'format'[,nls_format)

You can convert a DATE, NUMBER or expression into a character string.

The format may be either a CHAR format or a NUMBER format as required.

If no format is specified Oracle will use the default date format.
nls_format allows international formats to be applied.



Back to the Top

Simon Sheppard
SS64.com


 

 

additional query terms:
tochar