Re: Request for Informix Date field description

>From: Guy <guy@easysoft.com> >Date: Fri, 21 Mar 1997 12:10:13 +0000 >X-Informix-List-Id: <news.35592> > >I would be very grateful if someone would describe how Informix stores >it's date fields, are they stored as a count of seconds since some magic >date, or perhaps each segment (day, month, year, etc..) is stored in a >specific number of bits...??? This information is in the manual, mostly. DATE is stored as the number of days since a reference date. Day 1 was 1st January 1900. DATETIME values are stored differently. For a DATETIME YEAR TO SECOND, the value is stored in a DECIMAL structure as a large integer: 19970324120356. It becomes a fractional value if you specify YEAR TO FRACTION(x). Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>