TO_CHAR

Edit online

The TO_CHAR function returns a character string representation of the first argument in the format indicated by the optional format-string.

Character to Varchar

Read syntax diagramSkip visual syntax diagramTO_CHAR ( string-expression )

Timestamp to Varchar

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

Numeric to Varchar

Read syntax diagramSkip visual syntax diagramTO_CHAR(numeric-expression ,format-string )

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