Anyone found 2099 date in data
I wondered if anyone else has come across the following. Users have reported that their data was represented with a date of 2099 instead of 1999 for the period 17th November 1999 to 31st December 1999. Once we moved into the year 2000 the problem was apparently resolved. We use informix online v5.10.UC3 and isql 4.20.UC1 ------------------------------------------------------------------------ Audrey Buchan E-Mail: audrey_buchan@agilent.com CSG IS uktelnet: 3133323 Agilent Technologies telnet: 3133323 South Queensferry intn phone: 44 131 331 6323 EH30 9TG UK intn FAX: 44 131 331 6335 ------------------------------------------------------------------------ Available in IT : Mondays, Tuesdays and Wednesdays. Available in Complementary Therapy Room : Thursdays. Internal HP Homepage at URL http://homepages.sqf.hp.com/~audreyb/ External Homepage at URL http://www.billmcc.dial.pipex.com ------------------------------------------------------------------------ ("`-''-/").___..--''"`-._ ('6_ 6') `-. ( ).`-.__.`) (_Y_.)' ._ ) `._ `. ``-..-' ..`--'_..-_/ /--'_.' ,) (((,-'' (((,' (((.-' ------------------------------------------------------------------------
Audrey Buchan wrote: > I wondered if anyone else has come across the following. > > Users have reported that their data was represented with a date of 2099 > instead of 1999 for the period 17th November 1999 to 31st December > 1999. Once we moved into the year 2000 the problem was apparently > resolved. > > We use informix online v5.10.UC3 and isql 4.20.UC1 > This could have happened if your DB CENTURY setting was wrong and was indicating to the database it should use FUTURE rather than CURRENT century. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web) For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------
You need to make sure that the DBCENTURY variable is set properly ----- Original Message ----- From: Audrey Buchan <audreyb@sqf.hp.com> To: <comp.databases.informix@list.deja.com> Sent: Wednesday, January 26, 2000 6:48 AM Subject: Anyone found 2099 date in data > Message from the Deja.com forum: > comp.databases.informix > Your subscription is set to individual email delivery > > > I wondered if anyone else has come across the following. > > Users have reported that their data was represented with a date of 2099 > instead of 1999 for the period 17th November 1999 to 31st December > 1999. Once we moved into the year 2000 the problem was apparently > resolved. > > We use informix online v5.10.UC3 and isql 4.20.UC1 > > > ------------------------------------------------------------------------ > Audrey Buchan E-Mail: audrey_buchan@agilent.com > CSG IS uktelnet: 3133323 > Agilent Technologies telnet: 3133323 > South Queensferry intn phone: 44 131 331 6323 > EH30 9TG UK intn FAX: 44 131 331 6335 > ------------------------------------------------------------------------ > Available in IT : Mondays, Tuesdays and Wednesdays. > Available in Complementary Therapy Room : Thursdays. > > > Internal HP Homepage at URL http://homepages.sqf.hp.com/~audreyb/ > > External Homepage at URL http://www.billmcc.dial.pipex.com > > ------------------------------------------------------------------------ > > ("`-''-/").___..--''"`-._ > ('6_ 6') `-. ( ).`-.__.`) > (_Y_.)' ._ ) `._ `. ``-..-' > ..`--'_..-_/ /--'_.' ,) > (((,-'' (((,' (((.-' > > ------------------------------------------------------------------------ > > > > _____________________________________________________________ > Deja.com: Before you buy. > http://www.deja.com/ > * To modify or remove your subscription, go to > http://www.deja.com/edit_sub.xp?group=comp.databases.informix > * Read this thread at > http://www.deja.com/thread/%3C388EDF0D.3B60FA23%40sqf.hp.com%3E > > Sent via Deja.com http://www.deja.com/ Before you buy.