| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X | X |
Transforms date, time or timestamp value into a character string. The format appears below:
CHAR([x [, format]])
If present, x must evaluate to a date, time or timestamp value. If x is null, the result is null. The parameter format is a string format for date or time, as shown in the table below. If omitted, the system default format is used. The format parameter cannot be specified if x is a timestamp.
| Format | Name | Date Format | Time Format |
|---|---|---|---|
| ISO | International Standards Organization Standard | yyyy-mm-dd | hh.mm.ss |
| USA | IBM USA Standard | mm/dd/yyyy | hh:mm AM or PM |
| EUR | IBM European Standard | dd.mm.yyyy | hh.mm.ss |
| JIS | Japanese Industrial Standard Christian Era | yyyy-mm-dd | hh.mm.ss |
| LOCAL | Configured through the Options Utility. | User Defined | User Defined |
Examples are:
CHAR(birth_date, USA) CHAR(airtime, ISO) CHAR(auditstamp)