Re: YEAR 2000

MIS Dept wrote: > > Fco. Javier de la Fuente Ruiperez wrote: > > > > If i write the date 18/02/00. Informix set year to 1900 and not 2000. > > How i can resolve this? Exist a variable DBCENTURY > > Depends on which version of Informix OnLine you're using. I believe the > version which first includes DBCENTURY is 7.2x. > > Of course, SQL and 4GL aren't able to take advantage of this variable > yet. The updated releases are due 1997/4Q according to Informix. > > John Carlson > WH Smith, Inc. WHAT program are talking about ? I suppose you write the date in some kind of client, and it is on its own how it deals with non-century date. I believe it then sends the date as integer (to OnLine). Remember, DBCENTURY is client variable. Michal PS: to your question: what was your system date ? Did you set it to something after 2000 when trying to enter the date ? -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------