Neoview Database Administrator's Guide (R2.2)

Size or Range (1)DescriptionSQL DesignationType
YEAR no constraint(6)
MONTH 0-11
DAY no constraint
HOUR 0-23
MINUTE 0-59
SECOND 0-59
FRACTION(n) 0-999999
in which n is the number of
significant digits (default is 6;
minimum is 1; maximum is 6);
stored in 2, 4, or 8 bytes depending
on number of digits
Duration of time; value is in
the YEAR/MONTH range or
the DAY/HOUR/MINUTE/
SECOND/FRACTION range
INTERVALInterval
scale is the number of digits to the right of the decimal.
(1) The size of a column that allows null values is 2 bytes larger than the size for the defined data type.
(2) The maximum row size is 4036 bytes, but the actual row size is less than that because of bytes used by null
indicators, varchar column length indicators, and actual data encoding.
(3) Storage size is the same as that required by CHAR data type but store only half as many characters depending
on character set selection.
(4) Storage size is reduced by 8 bytes for storage of the varying character length.
(5) Storage size is reduced by 8 bytes for storage of the varying character length.
(6) The maximum number of digits in an INTERVAL value is 18, including the digits in all INTERVAL fields of the
value. Any INTERVAL field that is a starting field can have up to 18 digits minus the number of other digits in the
INTERVAL value.
141