Re: Millenium Problems

In article <341d50a1.27757372@gate.idg.no>, Nils Myklebust <Nils.Myklebust@idg.no> writes >"Mark D. Stock" <mdstock@informix.com> wrote: > >:Billy Wheeler wrote: >:> >:> On 13 Sep 97 at 15:07, Michelle Peridis wrote: >:> >:> > In the company I work for we run Informix-SE (4.11) on an Unix >:> > platform. Will we have problems coping with the Year 2000? It has >:> > always been common practice for us to set DBDATE=DMY2/ >:> >:> You should try setting DBDATE=DMY4/ and altering all your date fields >:> appropriately. You should consider an upgrade to (I think) 5.08 to >:> gain access to the very useful DBCENTURY environment variable. But >:> you *will* have problems if you don't change your DBDATE and date >:> fields... >: >:It's actually version 5.10, which is not available yet. :-) >: >:SE has always been year 2000 compliant. It's just down to how you >:capture and display the dates. So I agree with Billy, start converting >:to 4-digit years ASAP > >Additionally you should check your Unix for year 2000 compliance. >There are some versions with problems. If there is a problem and it >isn't too old there should be a patch available from your supplier. > Yep, we found a problem with Sequent Dynix. Our customer decided to test it without telling us. They set the date to 01/01/2000 and in 4GL TODAY became 01/01/1900! There is already a patch out. We are running a very old version (probably > 3 years old) since our customer has very little budget. > >Nils.Myklebust@idg.no >NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway >My opinions are those of my company >The Informix FAQ is at http://www.iiug.org -- David Williams