Converts numeric_expr to a character string.
Syntax
[TD_SYSFNLIB.] TO_CHAR ( numeric_expr [, format_arg [, NLS_param ] ] )
- TD_SYSFNLIB.
- Name of the database where the function is located.
- numeric_expr
-
A numeric argument.
If the conversion fails, '#' characters are returned. When the integer portion of the number is less than the digits specified in the format string, a string with a variable number of '#' characters is returned. The number of '#' characters returned is equal to the length of the maximum possible character string result based on the format string or data type of numeric_expr. This includes a '#' character representing the optional plus/minus sign.
For example:
SELECT TO_CHAR(12345678,'99')
returns '###'.
SELECT TO_CHAR(12345678,'99999')
returns '######'.
SELECT TO_CHAR(12345678,'99V9')
returns '####'.
- format_arg
-
A character expression.
format_arg is used to format the numeric values. If format_arg is omitted, numeric_expr is converted to a string exactly long enough to hold its significant digits.
If this syntax element is not valid, an error is returned.
For format_arg values, see TO_NUMBER.
- NLS_param
-
A character expression.