RE: Is this an informix leap year bug?

Not a bug, just the way the product behaves. The product has no way to know if you want February 28th or March 1st. You also cant do the following for the same reason SELECT DATE(DATETIME(1999-05-31) YEAR TO DAY - INTERVAL(1) MONTH TO MONTH) FROM systables WHERE tabid = 1; Will >===== Original Message 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? > >Thomas Tatum >http://www.koz.com/ >919.767.2129 ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------