TO_CHAR

Edit online

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


1  TO_CHAR ( character-expression )

Timestamp to VARCHAR


1  TO_CHAR ( timestamp-expression , format-string )

Decimal floating-point to VARCHAR


1  TO_CHAR ( decimal-floating-point-expression? ,format-string )