TO_CHAR scalar function

The TO_CHAR function returns a character representation of an input expression.

Character to varchar

Read syntax diagramSkip visual syntax diagramTO_CHAR(character-expression )

Timestamp to varchar

Read syntax diagramSkip visual syntax diagramTO_CHAR(timestamp-expression ,format-string,locale-name )

Decimal floating-point to varchar

Read syntax diagramSkip visual syntax diagramTO_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.