Re: (Q) Subtract 6 months from a date: result=error -1267!!!

Posted in 1994

Colonel Panic — 13 Apr 1994 05:04:42 GMT — source: Informix-list mailing list archive (1991-1998)

In article <2nuqj0$50q@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: >Note that in DB2, if you subtract 6 months from 31 March 1994, and then add >6 months back onto it, you get 30 March 1994, which is equally unintuitive. Not only that, the fact that the subtraction was successful violates the ANSI standard... -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland Disclaimer: Sender under influence of 1,3,7-trimethylxanthine