Re: Date Fields Entered: MM/DD/YY Stored: MM/DD/YYYY

In <2ia05uINN42t@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: >General question... If Informix was going to make it configurable, how >should the configuration be handled? Have some date, eg 49, where a >2-digit year less than that is 20xx, and later than that is still 19xx? >Set by environment variable? Or some other technique? I propose: $DBCENTURY_CUTOFF -- set to the year 49 does what you say above, but I could set it to 80, 20, whatever I want. Notice that setting it to 0 should imply that all years are 19xx, and 100 should imply all years are 20xx. Maybe -1 should mean "no two digit years allowed"... Maybe it should also be settable at run-time too... -- Andrew Burt aburt@du.edu "But if he was dying he wouldn't bother to carve "Aaaaargh", he'd just say it."