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.
June Tong — — source: Informix-list mailing list archive (1991-1998)
John Mattausch (pronet02@indirect.com) wrote:
: At the stroke of midnight all our programs turned into pumkins. Is any one
: aware of a problem with datetime or date veriables. (ERROR:1267). If so do
: you know of a work-around.
Error -1267:
The result of a datetime computation is out of range.
I suspect you are trying to manipulate CURRENT, possibly adding or subtracting
a year, which will give you an out of range date (eg. 2/29/97). I guess it's
too late now for your workaround, but I can't think of one anyway. The answer
is not to code things that way. This question often surfaces as "Why can't I
add 1 month to 1/31/96?" It's basically the same problem.
June
---- June Tong Informix Software ----
---- Senior Consultant (415) 926-6140 ----
---- International Support junet@informix.com ----
---- Location-du-jour: Taipei, Taiwan ----
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.