Re: Request for Informix Date field description

On Fri, 21 Mar 1997, Guy wrote: } Hi, } } 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...??? A date is stored as 4-bit integer that is the number of days since Dec 31, 1899... according to the Informix ESQL/C 7.1 manual.... may be different for other version... I've only been using informix for a year... so I'm still learning something new everyday... ;) Tony } } Cheers, } Guy } } |------ } Guy TJ Smithson, } Developer, Easysoft Limited } Tel: +44 (0)1332 220408 }