INTERVAL DAY TO 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 + 10) | '-d(precision) hh:mm:ss' |
| n where n is 1 - 6 |
CHARACTER(precision + n + 11) | '-d(precision) hh:mm:ss.s(n)' |
For example, for INTERVAL DAY (4) TO SECOND(3), the value may be ' 125 12:27:31.125 '.
The DAY field has two leading blanks. The first is for a sign, which is not present for positive intervals. The second is to preserve the fixed size of the DAY field at four digits.