Re: Is this an informix leap year bug?

Posted in 2000

Obnoxio The Clown — Tue, 29 Feb 2000 18:17:47 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Thomas B Tatum" <thomas@koz.com> > >We are using the following on Solaris 2.6: > >INFORMIX-Universal Server Version 9.14.UC6 > >==================== > >We have the following SQL: > >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? I thought today was the 29th? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com