Returns a string representation of first argument. Valid types are:
Datetime value if first argument is a date, time, or timestamp
Character string value if first argument is any type of character string
Integer value if first argument is a SMALLINT, INTEGER, or BIGINT
Decimal value if the first argument is a packed or zoned decimal number
Double-precision floating point value if first argument is a DOUBLE or REAL
Example:
Assume the column PRSTDATE has an internal value equivalent to 1988-12-25. The date format is *MDY and the date separator is a slash (/).
CHAR(PRSTDATE, USA)
Results in the value '12/25/1988'.
CHAR(PRSTDATE)
Results in the value '12/25/88'.