TIME 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(8) | 'hh:mi:ss' |
| n where n is 1 - 6 |
CHAR(9+n) | 'hh:mi:ss.ss...' |
The following table shows examples of how TIME types are exported in record and indicator modes.
| fractional_seconds_precision | Length | Example |
|---|---|---|
| 6 | 15 | '11:37:58.123456' |
| 0 | 8 | '11:37:58' |