Re: help, "02/29/00" - invalid day in date?

Posted in 1995

PLKapp — 19 Oct 1995 08:29:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> Everything works fine, except there are a few DATE fields which have >the value "02/29/00", that is, Feb. 29, 2000. This *is* a valid date, >but Informix bombs out saying that I have an "invalid day in date". > > I'm assuming that this is because of the leap-year thing; I've been >looking over the books, but the most I can find is that "xx/xx/00" may >default to 1900, not 2000. This is in fact not important to me, because >I am only displaying the date in "mm/dd/yy" format. Anyway, 2/29/1900 >was a leap-day, too. Check the books again. 1900 was NOT a leap year ("2/29/00" -> 2/29/1900). Leap years are divisible by 4, but not by 100 UNLESS also divisible by 400. It's about that time to start forgetting about 2 digit year abbreviations, cuz it gets confusing near the turn of the century. Paul Kapp ----> PLKapp@aol.com -OR- plk@usorder.com