Re: Millenium Problems

Posted in 1997

Peter Lancashire — Thu, 18 Sep 1997 17:24:40 +0100 — source: Informix-list mailing list archive (1991-1998)

Michelle Peridis wrote: > > You will have to excuse if I don't seem to supply enough information, > but any assistance would be greatly appreciated. > > I would like some information regarding "Millenium bugs" (I hope I spelt > it right). > > 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/ > > Michelle. There is a more subtle problem with non-dates. Do you use any codes which include two digits which represent the year? These may give problems. Of course, it is not an Informix problem. What is an Informix problem is a bug that appeared in some versions of the engines where sorting on substrings sorted incorrectly. Of course, these will sort really incorrectly after 2000 if they have only two digits. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.