Re: SINIX und das Jahr 2000
Erik Vellmete wrote:
> Axel Sander wrote:
>
> > Und was ist mit dem 29.2.2000? Irgendwo habe ich gelesen, dieses Datum
> > w'rde von Informix als ung'ltig abgelehnt werden (habe ich noch nicht
> > selbst gepr'ft).
> >
>
> There will be no problem on IDS 9.14UC1:
> select distinct date('2000-03-31') - date('1999-12-31') from systables;> returns 91, that's right, isn't it? You can use the constant
> date('2000-02-29') as well.
>
> Erik
Try this ( Used DS 7.20 UC2 on HP/UX 10.20):
DBCENTURY=F
CREATE TABLE Y2K_T1( leap_year datetime year to day );
INSERT INTO Y2K_T1 VALUES ('20000-02-29'); ( no problem)
INSERT INTO Y2K_T1 VALUES ('00-02-29'); (problem:1263: A field in a datetime or interval value is out of range or incorrect.)
00 should be expanded to 2000 but obvioulsly was expanded to 1900 (and this
is no leap year).
Hans-Juergen Thiess, BB-Data GmbH / Berlin