Re: Storage of Null Informix dates

Posted in 1997

Art S. Kagel — Tue, 25 Nov 1997 17:48:22 -0500 — source: Informix-list mailing list archive (1991-1998)

Guy Smithson wrote: > > Hi, > > Does anyone know how NULL/Blank Informix dates are stored. I have a > sample data file and the 4 byte integer containing a NULL Informix-Date > has it's highest bit set to one (0x80000000). Is this always the case, > or do other storage formats for NULL/Blank Informix-Dates exist also > (like 0x00000000) ? The value 0x00000000 is the Informix Base or zero date which corresponds to 12/31/1899 so that day 1 (0x00000001) is 1/1/1900. The NULL date value is 0x80000000. Art S. Kagel