DB2 Version 10.1 for Linux, UNIX, and Windows

TO_CHAR scalar function

The TO_CHAR function returns a character representation of an input expression that has been formatted using a character template.

Character to varchar


>>-TO_CHAR--(--character-expression--)-------------------------><

Timestamp to varchar


>>-TO_CHAR--(--timestamp-expression--+--------------------------------------+--)-><
                                     '-,--format-string--+----------------+-'      
                                                         '-,--locale-name-'

Decimal floating-point to varchar


>>-TO_CHAR--(--decimal-floating-point-expression--+---------------+--)-><
                                                  '-format-string-'

The schema is SYSIBM.

The TO_CHAR scalar function is a synonym for the VARCHAR_FORMAT scalar function.