TO_CHAR scalar function The TO_CHAR function returns a character representation of an input expression. Character to varcharTO_CHAR(character-expression ) Timestamp to varcharTO_CHAR(timestamp-expression ,format-string,locale-name ) Decimal floating-point to varcharTO_CHAR(decimal-floating-point-expression ,format-string,locale-name ) The schema is SYSIBM. The TO_CHAR scalar function is a synonym for the VARCHAR_FORMAT scalar function.