Communicator e3000 MPE/iX Release 6.5 (Non-Platform Software Release C.65.00 (30216-90291)

Chapter 6 167
Announcing a Post 6.5 Release Patch
IMAGE/SQL Date Mapping Enhancement
Format(TI)Type StorageType #Bytes Explanation
Notes
1. MM3000 dates are represented as in the MM3000 product which uses the ASCII "A"
through "Z" for decades starting with the year 2000.
2. lowvalue will be displayed as '9900-01-01',
highvalue will be displayed as '9999-12-31', and
Format (TI) Storage Type Bytes Explanation
DT1 (I4,J4,K4) longint 8 MPE time-stamp
(microseconds from 1970-01-01)
DT2 (I2,J2,K2) integer 4 Upper 2 bytes: year
next byte: month of year
DT3 (I2,J2,K2) integer 4 Upper 2 bytes: year
bottom 2 bytes: day of year
DT4 (I2,J2,K2) integer 4 Upper 23 bits: # years from 1900
bottom 9 bits: day of the year.
(analogous to the existing CALENDAR format.)
DT10 (I2,J2,K2) integer 4 Seconds from 1970-01-01
(POSIX.1 time() format;
valid through 2038-01-18)
DT14 (I1,J1,K1) shortint 2 Upper 7 bits: #years from 1900
Lower 9 bits: day of the year
(CALENDAR format; valid up to 2027-12-31)
DT15 (I2,J2,K2,P8) integer 4 YYMMDD date
DT16 (I2,J2,K2,P8) integer 4 MMDDYY date
DT17 (I2,J2,K2,P8) integer 4 DDMMYY date
DT18 (I2,J2,K2) integer 4 YYYYMMDD date
DT25 (X6,U6,K3,Z6) ASCII 6 YYMMDD date
DT26 (X6,U6,K3,Z6 ASCII 6 MMDDYY date
DT27 (X6,U6,K3,Z6) ASCII 6 DDMMYY date
DT35 (X6,U6,K3) ASCII 6 YYMMDD date YY:MM3000 date
DT36 (X6,U6,K3) ASCII 6 MMDDYY date YY:MM3000 date
DT37 (X6,U6,K3) ASCII 6 DDMMYY date YY:MM3000 date
DT38 (X8,U8,K4,Z8) ASCII 8 YYYYMMDD date
BB1 (K2) 4 Business Basic SHORT DECIMAL type
BB2 (K4) 8 Business Basic DECIMAL type