TIMESTAMP WITH TIME ZONE 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(25) | 'yyyy-mm-dd hh:mi:ss-hh:mi' or 'yyyy-mm-dd hh:mi:ss+hh:mi' |
| n where n is 1 - 6 |
CHAR(26+n) | 'yyyy-mm-dd hh:mi:ss.ss…-hh:mi' or 'yyyy-mm-dd hh:mi:ss.ss…+hh:mi' |
The following table shows examples of how TIMESTAMP WITH TIME ZONE types are exported in record and indicator modes.
| fractional_seconds_precision | Length | Example |
|---|---|---|
| 6 | 32 | '2000-01-01 11:37:58.123456+08:00' |
| 0 | 25 | '2000-01-01 11:37:58-08:00' |