Re: Is this an informix leap year bug?

Thomas B Tatum wrote: > 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? And should March 31, 2000 - 1 month = February 29? Informix does not assume you want the nearest legal date. Avoid such simplistic calculations involving intervals, they'll bite you! -- Colin