Re: Is this an informix leap year bug?

Posted in 2000

Chuck Renaud — Tue, 29 Feb 2000 12:32:47 -0600 — source: Informix-list mailing list archive (1991-1998)

> select date(today - interval(1) year to year) from systables where tabid = > 1; > > and get > > 1267: The result of a datetime computation is out of range.> > Is this a bug with the database? Shouldn't it automatically return > 02/28/1999 in this case? No, it's not a bug. How is the engine going to know if you want 2/28/99 or 3/1/99?

↪ replying to Chuck Renaud

Carlson@WHSmith — Tue, 29 Feb 2000 14:02:54 -0500 — source: Informix-list mailing list archive (1991-1998)

Chuck Renaud wrote: > > > select date(today - interval(1) year to year) from systables where tabid = > > 1; > > > > and get > > > > 1267: The result of a datetime computation is out of range.> > > > Is this a bug with the database? Shouldn't it automatically return > > 02/28/1999 in this case? > > No, it's not a bug. How is the engine going to know if you want > 2/28/99 or 3/1/99? Of course, date(today - 365 units day) might get around the issue, except in a leap year . . . 8-) -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */