There are two versions of the CHAR function, one for converting an argument to a character string, and one for converting a date, time, or timestamp value to a standard format. The version that takes one argument converts its argument to a character string. For information about using CHAR to convert a date, time, or timestamp value to a standard format, see CHAR: Converting to a Standard Date-Time Format.
Is the value to be converted.
This function returns a character string whose length is of sufficient size to hold the value.
CHAR converts a value to a character string. This example,