Re: date manip. prob with AIX & OnLine 5.05.UC6

Right you are, JL. When I changed the system date to Oct 8, and reran the sql statement, it returned correct value. Jonathan Leffler writes: } } On Fri, 7 Nov 1997, Colin M McGrath wrote: } } } If the following SQL error is the result of the same bug (B55557), } } a subtraction operation's assumed connection to the bug may be a incorrect. } } Subtraction is a representative way of running into the problem, and the } most commonly occurring one in practice. I doubt that it was the sole way } of running into the problem -- many operations on a DATETIME field that } produced a DAY TO DAY value of 31 in a 30-day month (or 28 or 29 day month) } failed. This has since been fixed. The PTS database recorded VRF-IMP } (verified implicitly) for the problem in version 4.1x, and the version 4.1x } server bugs have since been closed in bulk. } } } I get the error (1263) with OnLine 5.05.UC1 (though 4.10.UE4 works correctly). } } (OnLine 5.05.UC6) } } } } select extend(date("10/31/97"), day to day) } } from systables } } where tabid = 1; } } } } (expression) } } } } 1263: A field in a datetime or interval value is out of range or incorrect. } } Unless a code inspection showed another problem causing this, I'd treat it } as a manifestation of B55557. -- _____________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA Standard Disclaimers Apply | |___________________________________________________________________|