Interval Data Type Length

The following rules are used to determine the length of an interval data type in characters. Length is expressed in number of characters. The number of bytes depends upon the character set. The length includes the following values added together:

Specific column length values for each interval data type are contained in “Column Size” later in this appendix.