SQL - Scalar functions - TO_CHAR


Volta a página anterior

Volta ao Menu das scalar functions

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

TO_CHAR

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

Character to varchar

TO_CHAR(character-expression )

Timestamp to varchar

TO_CHAR(timestamp-expression ,format-string,locale-name )

Decimal floating-point to varchar

TO_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.

© Copyright IBM Corp.