Re: NEW CENTURY ROLLOVER

}>>>>>>>>> Perry's response to Ed Schaefer <<<<<<<<<< Oops. I guess you had a little case of bad planning, huh? All you gotta do is expand all your date fields by two characters and then reset DBDATE to mdy4/. Informix has always stored dates as an integer, so all you have to do is what I mentioned above and you'll be set. At FourGen, we had a bunch of stuff set for using mdy2/ also. But we just went through all our .per's, expanded the fields to hold the four digit year and now we're set forever. } From: olded@ix.netcom.com (Ed Schaefer ) } Subject: Re: NEW CENTURY ROLLOVER } Date: 6 Jan 1996 04:12:41 GMT } To: informix-list@rmy.emory.edu } } In <4ck96s$n1s@news-2.csn.net> edbid@csn.net (Edward A. Bidinotto) } writes: } > } >Will there be any problems or anything to consider with INformix when } we } >roll over to the year 2000 ? } >I couldn't think of anything right off but someone asked me and I } >couldn't come up with a good answer. } > } >Any info would be appreciated. } > } >Tks..Ed } } Ed: } } May seem rather trivial but for those of us who have DBDATE set to } MDY2/, entering 00 in the year part of the date field now signifies } 1900 instead of 2000. } } We have 4 years to get it fixed! } } ed } schaefer } } -perryd (Guru) ==================================================================== = Perry Dillard - Chief Architect Direct Dial: (206)517-6430 = = FourGen Software, Inc. FAX: (206)522-0054 = = FourGen Building Tech. Support: (800)444-3398 = = 115 NE 100th Street Sales: (800)333-4436 = = Seattle, W.A. 98125-8098 = = = = e-mail: perryd@fourgen.com Web Site http://www.fourgen.com = ====================================================================