Re: Is this an informix leap year bug?

Posted in 2000

Larry Kemmerling — Tue, 29 Feb 2000 10:40:03 -0800 (PST) — source: Informix-list mailing list archive (1991-1998)

>>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? The following works without error on 7.31.UC5: select date(today - interval(4) year to year) from systables where tabid = 1 The key, as the other-worldly Obnoxio pointed out, is that there wasn't a 2/29/1999. Larry Kemmerling Product Systems Engineer AT&T Wireless Services Aviation Communications Division