TO_CHAR scalar function

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

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)

Decimal floating-point to VARCHAR

Read syntax diagramSkip visual syntax diagramTO_CHAR(decimal-floating-point-expression ,format-string )

The TO_CHAR scalar function is identical to the VARCHAR_FORMAT scalar function. For more information, see VARCHAR_FORMAT scalar function.