Re: Informix 3.3-How do I decipher date data type?

Darrel, Unless my memory is addled (not impossible), the DATE and EDATE types in Informix 3.3 (pre-SQL) was essentially the same as in the Informix SQL-based products, ie the value was the integer number of days since 31 December 1899 (making 1 January 1900 into day 1). The reason for most of the date values having the first two bytes 0 is that 5th June 2079 has the hex representation 0xFFFF, so only dates prior to 31st December 1899 and dates after 5th June 1899 require any of the high-order bits set. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: darreld@access1.digex.net (Darrel Davis) >Subject: Informix 3.3-How do I decipher date data type? >Date: 16 Jul 1994 09:05:36 -0400 >X-Informix-List-Id: <news.7630> > >I am writing a small program that will unload an informix 3.3 '.dat' >file. The only problem is the date type. If I do an 'od -bc' on >the file, it shows it to be 4 bytes, the first two of which are >usually '\\0'. I can't figure out how to use it.