CHAR

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