Re: Y2K Solution

Eric Rawson wrote: > > I want to implement Year 2000 solution for an Informix 4GL and ESQL/C > system by use of the DBCENTURY value (setting it to "C"). > > a. Is this supported by Informix in Standard Engine as well as Online > ? That's a very good question. It is documented to be in SE 5.10, but I can't find any info for version 7.x. > b. Are there any problems anyone has encountered using DBCENTURY ? I haven't heard of any. > c. Is it correct to assume that the Year 2000 problem for Informix is > "fixed" by use of DBCENTURY ? Weeell, Informix has never HAD a Year 2000 problem. :-) The problem is when applications supply only two digits for a year. Using DBCENTURY helps implement solutions without rewriting lots of code. > d. Will all date fields held as "date" types but with 2 digit years > be handled OK ? Date values have always effectively stored four digit years. So there is no change to the actual storage OR display. DBCENTURY just changes the conversion of two digit years to four digit years. Without DBCENTURY Informix has always added 1900 to the value. So the answer to d. is 'yes'. ;-) Hope this helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+