Re: help, "02/29/00" - invalid day in date?
Posted in 1995
Topics: General Discussion
In <464err$lq3@cssun.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: >No, it isn't a valid date -- 1900 was not a leap year. >The rule is simple; if it is a 2-digit year, 1900 is added to the year. >Because 00 is a 2-digit year, 1900 is added to it. > *** USE 4 DIGITS FOR THE YEAR *** ... >Again, the rules are not all that hard. There is a leap year when the year >is evenly divisible by 400 (hence 2000 is a leap year); otherwise, if it is >evenly divisible by 100 it is not a leap year (hence 1900, 1800 and 2100, >etc are not leap years); otherwise, if it is divisible by 4 is is a leap >year (hence 1992, 1996, etc). ... >Use 4 digits for the year -- to enter 2000 into an Informix database, you >have to enter 2000. >Yours, >Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> Thanks to Jonathan and everybody else who helped me out on this one. I guess it's true, you learn something new every day. Thanks again, Brian Park bp006c@uhura.cc.rochester.edu