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

Quentin North (nsqjn@ifl.co.uk) wrote: : In a Online 5 query we are subtracting 6 months from a date stored in a table. However, when this date is 31 March 94 subtracting 6 months yields an SQL error -1267. : In DB2 we have no problem with this and subtracting 6 months from 31 March 94 yields 30 September 93. Is this a bug in Informix? What is the syntax you are using for this subtraction? (Please give an example of how you are using it).... I have never had a problem with this... Informix has a whole appendix dedicated to date manipulation in it's sql and 4gl manuals... -- -jcm@nccom.com CALL Phone Vision! FREE and Fun! -John C. Musselman, Systems Engineer San Diego, CA........ (619) 220-4884 -North County Communications Phoenix, AZ.......... (602) 265-6100