Re: Is this an informix leap year bug?

Posted in 2000

Seth Grimes — Tue, 29 Feb 2000 13:41:39 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

What a laugh. If memory serves me correctly, if you try a similar query in Illustra you'll get a similar result. As I recall, Illustra couldn't handle subtracting a one-month interval from a date of March 29 or 30. Seth On Tue, 29 Feb 2000, Thomas B Tatum wrote: > INFORMIX-Universal Server Version 9.14.UC6 > > 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? > > Thomas Tatum > http://www.koz.com/ > 919.767.2129 > > -- Seth Grimes Alta Plana database & Web / design & development grimes@altaplana.com http://altaplana.com 301-873-8225