TIMESTAMP types are imported and exported in record and indicator modes as CHARACTER data using the ANSI format string and the site-defined client character set.
| fractional_seconds_precision | Data Type | Format |
|---|---|---|
| 0 | CHAR(19) | 'yyyy-mm-dd hh:mi:ss' |
| n where n is 1 - 6 |
CHAR(20+n) | 'yyyy-mm-dd hh:mi:ss.ss…' |
The following table shows examples of how TIMESTAMP types are exported in record and indicator modes.
| fractional_seconds_precision | Length | Example |
|---|---|---|
| 6 | 26 | '1999-01-01 23:59:59.999999' |
| 0 | 19 | '1999-01-01 23:59:59' |