Re: Informix 4.1 inquiry

Peter Lancashire wrote: > Jonathan Leffler wrote: > > FGAnderson wrote: > > > I know I am behind but does someone have information on > > > what makes Informix 4.1 Y2K non-compliant. We are > > > currently using Informix/4gl, Informix/sql, Informix/SE > > > We have modified the code to use a 4 digit year with > > > no problems. Any info would be appreciated. > > > > The only thing that causes trouble is the handling of 2-digit years > > on data entry. > > <much snipping> > > Excuse my ignorance, but is there a problem with 29 Feb 2000 and dates > after it? Which versions does this problem apply to? No. The only time there is a problem with 29 February 2000 is when you try to enter it as 29/02/00, which the 4.1 product interprets as an attempt to enter 29/02/1900, which was not a valid date, so it gets rejected. > On a slightly different angle: another thing which causes trouble is > all-digit years when some users are from the USA and others are from > Europe or any users are not sure or the software originates in the USA > and is used in Europe, etc.... > > What date is 10-11-1998? I always use 10 Nov 1998. That depends on the setting of DBDATE, of course. As far as I'm concerened, it means 10th November 1998 when I type it, and 11th October when my American colleagues type it. I'm bilingual in English and American. I do all my database access with DBDATE=DMY4/. If your software doesn't let you choose which value of DBDATE (because the shell script that runs it force-sets the value of DBDATE), then you should pester the programming staff into allowing you to set the value of DBDATE somehow, or persistently enter the dates all wrong (or tell them that you can't enter dates at the end of the month) until they get the message. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>