TO_CHAR

The TO_CHAR function returns a character string representation of a timestamp value that has been formatted using a specified character template.

Start of change 
Read syntax diagram
Character to VARCHAR

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


Read syntax diagram
Timestamp to VARCHAR

>>-TO_CHAR--(--timestamp-expression--,--format-string--)-------><


Read syntax diagram
Decimal floating-point to VARCHAR

>>-TO_CHAR--(--decimal-floating-point-expression--+------------------+--)-><
                                                  '-,--format-string-'      
End of change

The schema is SYSIBM.

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