INTERVAL SECOND types are imported and exported in record and indicator modes as CHARACTER data using the client character set.
| fractional_seconds_precision | Data Type | Format |
|---|---|---|
| 0 | CHARACTER(precision + 1) | '-s(precision)' |
| n where n is 1 - 6 |
CHARACTER(precision + n + 2) | '-s(precision).s(n)' |
For example, for INTERVAL SECOND(3,2), the value may be '-127.35'.