Re: File format for "date" datatype.

>From: uunet!reef.cis.ufl.edu!corwin (Jack Rusher) >Subject: File format for "date" datatype. >Date: Thu, 14 Jan 93 17:36:42 GMT >X-Informix-List-Id: <news.2494> >We have an old version of Informix running on a Xenix machine. How old? Informix-SQL + SE or even older and Informix 3.30? >I need to migrate the data into an ASCII file ... but I do not know the >internal file format of the Informix "date" type. It appears to be a >large unsigned integer (which is not the same as normal Unix dates). In ISQL + SE: Day 1 was 1st January 1900. I'm not sure whether the same format was used in 3.30, but I suspect it was. But the normal file format for a date is controlled by DBDATE, so on this side of the Atlantic, dates normally look like 15/01/1993, whereas on your side, they tend to look like 01/15/93. This format is interpreted sensibly by dbload and the LOAD statement. You should look in the ESQL/C manuals for date handling routines -- there shouldn't be any need for you to worry about reworking the conversions. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>