Neoview Database Administrator's Guide (R2.2)

Size or Range (1)DescriptionSQL DesignationType
1 to 18 digits. Byte length equals
the number of digits. Sign is stored
as the first bit of the leftmost byte.
Decimal number with
optional scale; stored as
ASCII characters; signed or
unsigned for 1 to 9 digits;
signed required for 10 or
more digits
DECIMAL (1,scale) to
DECIMAL (18,scale)
Decimal number
1 to 18 digits, stored as DECIMALDecimal number; same as
DECIMAL
PIC S9V9 DISPLAY to
PIC S9(18) DISPLAY
YEAR 0001-9999
MONTH 1-12
DAY 1-31
DAY constrained by MONTH and
YEAR
HOUR 0-23
MINUTE 0-59
SECOND 0-59
FRACTION(n) 0-999999
in which n is the number of
significant digits, from 1 to 6
(default is 6; minimum is 1;
maximum is 6). Actual database
storage is incremental, as follows:
YEAR in 2 bytes
MONTH in 1 byte
DAY in 1 byte
HOUR in 1 byte
MINUTE in 1 byte
SECOND in 1 byte
FRACTION in 4 bytes
Point in time, using the
Gregorian calendar and a 24
hour clock system. The five
supported designations are
listed below.
Date-Time
Format as YYYY-MM-DD; actual
database storage size is 4 bytes
DateDATE
Format as HH:MM:SS; actual
database storage size is 3 bytes
Time of day, 24 hour clock,
no time precision
TIME
Format as HH:MM:SS.FFFFFF;
actual database storage size is 7
bytes
Time of day, 24 hour clock,
with time precision
TIME
Format as YYYY-MM-DD
HH:MM:SS; actual database
storage size is 7 bytes
Point in time, no time
precision
TIMESTAMP
Format as YYYY-MM-DD
HH:MM:SS.FFFFFF; actual
database storage size is 11 bytes
Point in time, with time
precision
TIMESTAMP
140 Data Types