TO_CHAR (number)

Purpose

This function converts a number into a string.

Syntax

to_char (number)::=

Usage Notes

For information, refer to the Date/Time Format Models.

Example

SELECT TO_CHAR(12345.6789) TO_CHAR;

SELECT TO_CHAR(12345.67890, '9999999.999999999') TO_CHAR;

SELECT TO_CHAR(-12345.67890, '000G000G000D000000MI') TO_CHAR;