Date Problem reading 1 day ahead with today command

Posted in 2000

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

SJE2967 — 13 Mar 2000 16:22:02 GMT — source: Informix-list mailing list archive (1991-1998)

System BIOS read correct date, Xenix System shows current day. When I use the today command the system gives me the date plus 1 day???. Using Infromix 4.2 SQL and 4GL with the SE. Running this on a SCO Xenix Box. any help?? Steve sje2967@aol.com

↪ replying to SJE2967

Michael Krzepkowski — Mon, 13 Mar 2000 16:41:36 GMT — source: Informix-list mailing list archive (1991-1998)

Hi! Have you installed all required patches on Xenix and recompiled the application (Y2K stuff....)? Michael SJE2967 wrote: > System BIOS read correct date, Xenix System shows current day. When I use the > today command the system gives me the date plus 1 day???. Using Infromix 4.2 > SQL and 4GL with the SE. Running this on a SCO Xenix Box. > > any help?? > > Steve > sje2967@aol.com

↪ replying to SJE2967

Watawinona — 13 Mar 2000 20:16:55 GMT — source: Informix-list mailing list archive (1991-1998)

>Subject: Date Problem reading 1 day ahead with today command >From: sje2967@aol.com (SJE2967) >Date: 13.03.00 17:22 W. Europe Standard Time >Message-id: <20000313112202.22003.00001544@ng-cd1.aol.com> > >System BIOS read correct date, Xenix System shows current day. When I use >the >today command the system gives me the date plus 1 day???. Using Infromix 4.2 >SQL and 4GL with the SE. Running this on a SCO Xenix Box. > > >any help?? > >Steve >sje2967@aol.com > 4.x and 6.x are obsolete, move to Dynamic 4GL 3.xx Nona

↪ replying to SJE2967

Jonathan Leffler — Tue, 14 Mar 2000 23:33:02 GMT — source: Informix-list mailing list archive (1991-1998)

SJE2967 wrote: > System BIOS read correct date, Xenix System shows current day. When I use the > today command the system gives me the date plus 1 day???. Using Infromix 4.2 > SQL and 4GL with the SE. Running this on a SCO Xenix Box. SCO Xenix? Are you sure it is ISQL 4.20 and I4GL 4.20? I'm not! I don't know when SCO Xenix was dropped from Informix's porting list, but I'd be surprised if it was less than 5 years ago. Which version of SE are you using? Unless you are using 4.20 ISQL and I4GL and 5.10 SE, you are now finding out why Informix made the old versions obsolete before the start of this year -- they do not handle 2000 as a leap year. The off-by-one makes me strongly suspect that you are using a Y2K-noncompliant version of SE at least, and I'm dubious about your I4GL and ISQL too. Someone else asked whether you have all the SCO Xenix Y2K patches; I'll merely reiterate the question, but I'll add that I don't think that is actually a factor in your problem. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>

↪ replying to SJE2967

Peter — Thu, 16 Mar 2000 09:06:57 GMT — source: Informix-list mailing list archive (1991-1998)

This is the problem of the 29th Feb of this year! Your Infx is not full y2k ready. Try a day before 29.2.2000. Cheers Peter On 13 Mar 2000 16:22:02 GMT, sje2967@aol.com (SJE2967) wrote: >System BIOS read correct date, Xenix System shows current day. When I use the >today command the system gives me the date plus 1 day???. Using Infromix 4.2 >SQL and 4GL with the SE. Running this on a SCO Xenix Box. > > >any help?? > >Steve >sje2967@aol.com

Glossary

4GL (Informix-4GL)