Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Curtis Bennett — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.