date standards

What date standard is used, if any, in the 7.3x/9.x engines: -International Org. for Standardization's CCYYMMDD format -ANSI X3.30-1985 -ANSI X3.51-1994 -ISO 8601:1988 Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

From what I've been able to tell is dates are stored as the number of days since December 31, 1899. That makes day 1 as Jan 1, 1900. Any formatting is done in the application. Negative dates are used prior to 1900. S.W. <nguffey@my-deja.com> wrote in message news:7rquf6$ckm$1@nnrp1.deja.com... > What date standard is used, if any, in the 7.3x/9.x engines: > -International Org. for Standardization's CCYYMMDD format > -ANSI X3.30-1985 > -ANSI X3.51-1994 > -ISO 8601:1988 > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.

Correct for DATE type columns. DATETIME type columns are stored as an Informix DECIMAL type with two base100 digits for century and year, and one base100 digit each for month, day, hour, minute, and second if needed and one to 3 base100 digits for fraction as needed. Also part of the definition, and returned but not stored, are status bytes indicating the starting and ending precision of the DATETIME which are derived from the column's syscolumn record. So in direct answer, yes century is stored for DATETIME also. Art S. Kagel Steven Wilcoxon wrote: > > From what I've been able to tell is dates are stored as the number of days > since > December 31, 1899. That makes day 1 as Jan 1, 1900. Any formatting is > done in the application. Negative dates are used prior to 1900. > > S.W. > > <nguffey@my-deja.com> wrote in message news:7rquf6$ckm$1@nnrp1.deja.com... > > What date standard is used, if any, in the 7.3x/9.x engines: > > -International Org. for Standardization's CCYYMMDD format > > -ANSI X3.30-1985 > > -ANSI X3.51-1994 > > -ISO 8601:1988 > > > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't.