Table 4-1 lists the character representations that a DB2 access service returns to the client application when you choose char as the output type. The table includes configuration property values for date and time character forms. For example, DB2 DATE type can convert to Open Client and Open Server CS_CHAR type in one of the four character formats shown in the table.
DB2 input type |
Open Client and Open Server character form returned to the client application |
|---|---|
DECIMAL (scale = 0) |
±n |
DECIMAL (scale > 0) |
±n.n |
DECIMAL (scale = precision) |
±.n |
DATE |
char_eur format dd.mm.yyyy char_iso format yyyy-mm-dd char_jis format yyyy-mm-dd char_usa format mm/dd/yyyy |
REAL |
±n.nnnnnnnE±nn |
FLOAT |
±n.nnnnnnnnnnnnnnnnE±nn |
INT |
±nnnnnnnnnn |
SMALLINT |
±nnnnn |
TIME |
char_eur format hh.mm.ss in 24-hour clock time char_iso format hh.mm.ss in 24-hour clock time char_jis format hh:mm:ss in 24-hour clock time char_usa format hh:mm [AM | PM] in 12-hour clock time |
TIMESTAMP |
char_eur format dd.mm.yyyy hh.mm.ss char_iso format yyyy-mm-dd-hh.mm.ss.nnnnnn char_jis format yyyy-mm-dd hh:mm:ss char_usa format mm/dd/yyyy hh.mm [AM | PM] |
