4GL Year 2000 question (bug?)

Posted in 1999

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

Candy McCall — Wed, 13 Oct 1999 14:20:09 -0500 — source: Informix-list mailing list archive (1991-1998)

Our Platform is: SCO Unix 5.0.4 Informix 4GL 7.20.UD1 SE 7.23.UC1 DBCENTURY is set to C. When we enter a date as 022800, it translates to 02/28/2000 in the date field. However, when we enter a date as 022900, it gives an "Error in field" message. When we enter 4 digits for the year as in 02 29 2000, it gives 02/29/2000. Has anyone else encountered this problem? If so, do you know in which release it is fixed? Thanks! Candy -- Candy McCall ONLINE Computing, Inc. (candym@olcinc.com)

↪ replying to Candy McCall

Carlson@WHSmith — Thu, 14 Oct 1999 09:38:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Haven't seen it in IDS 7.30.uc7 and 4gl 7.20.ud6. John Carlson Informix DBA WHSmith USA Candy McCall wrote: > > Our Platform is: > > SCO Unix 5.0.4 > Informix 4GL 7.20.UD1 > SE 7.23.UC1 > > DBCENTURY is set to C. > > When we enter a date as 022800, it translates to 02/28/2000 > in the date field. > However, when we enter a date as 022900, it gives an > "Error in field" message. > When we enter 4 digits for the year as in 02 29 2000, it > gives 02/29/2000. > > Has anyone else encountered this problem? If so, do > you know in which release it is fixed? > > Thanks! > > Candy > -- > Candy McCall > ONLINE Computing, Inc. > (candym@olcinc.com)

↪ replying to Candy McCall

JLK62 — 14 Oct 1999 14:23:01 GMT — source: Informix-list mailing list archive (1991-1998)

I found the same thing (SCO 3.2.5.0.4 and Informix Dynamic Server 7.22.UC3). Upgraded to IDS 7.30.UC2. (Jonathan Leffler thought it was either bug B65050 or B69050). Don't forget to upgrade any tools that you use - the SDK I was compiling with also contained the same bug. Hope that helps. Joe

Glossary

4GL (Informix-4GL)