Re: Year 2000
Lester Knutsen wrote:
}
}Jonathan,
}
}> Jonathan Leffler asked:
}> Note 2: I've heard a report that the Informix SQL-based products prior
}> to release 4.0 have problems with the year 2000. I've been unable to
}> substantiate that report, but if you are still using them, it would be
}> worth checking rather carefully. If anybody does have access to the
}> old products (eg ISQL 2.00, 2.10 or 2.10.03) and can check whether the
}> old products recognize 2000-02-29 as a valid date with DBDATE="y4md-",
}> I would appreciate the feedback.
}
}I tried this on an old NCR Tower using INFORMIX-SQL Version 2.10.00A.
}It accepts 02/29/2000 as a valid date.
}
}Here is the script I used and some output:
}
}create database datechk;
}create table datechk
} ( recno serial,
} recdate date );
}insert into datechk values ( 0, "01/01/2000" );
}insert into datechk values ( 0, "02/29/2000" );
}
}$ isql datechk -
} select * from datechk;
} recno recdate
}
} 1 01/01/2000
} 2 02/29/2000
}
}
}Regards - Lester
We did a similar check on our machines (SE 2.10.03K; I4GL 1.10.03K1) a few
weeks back, which correctly accepted and displayed 29/2/2000. This is with
DBDATE='DMY4'.
John, you asked about a DBDATE of 'Y4MD-'. Would a different DBDATE format
have a different effect on the test?
Steve Fabac's post of 8/7/97 said that he had a problem when he changed the
m/c date to 29/2/2000 and tried to insert ... values (TODAY). We were
intending to do this test as well, but the decision came through to upgrade
anyway, so we decided that it was a moot point for us. BTW , has anyone done
this test on a later version of Informix?
Lesley