Re: Is this an informix leap year bug?

It doesn't appear to be. It should return an error. What date is that? 1 year from today is what day? March 1st, Feb 28th? If you do : select date("02/29/2000") - 4 units year from systables where tabid = 1 You get 1996-02-29, which is correct. But there is no "defined" 1 year ago from today. It's undefined. From: "Thomas B Tatum" <thomas@koz.com> Reply-To: ius-users@iiug.org To: "'Informix_List'" <informix-list@iiug.org>, "Ius-Users@Iiug. Org" <ius-users@iiug.org> Subject: Is this an informix leap year bug? Date: Tue, 29 Feb 2000 12:48:04 -0500 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 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com