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

Hi! I reproduced the error on my platform, but I didn't set my system date to Nov 1st. Instead, I executed the following SQL today (November 6, 1997): select extend(today - 6, month to month), extend(today - 6, day to day) from systables where tabid = 1 If I subtract 5 or 7 from today, I get the results I expect. It seems the error only pops up when I try to get to Oct. 31st. Strange, but that shows that this error may not be platform specific and it exists in 5.05.UC1 and 5.05.UC6. As another test, I subtracted 37 from today, to see if I'd get the problem trying to get Sept. 30, and it worked fine (returned 9 30 as expected). What's so special about October 31st, 1997? My platform is Digital Unix 3.0B, OnLine 5.05.UC1. At 12:26 PM 11/6/97 EDT, you wrote: } } }Hi! } }Did you set the system date to Nov 1st first? (It only failed on the first }of the month!) } }Nigel Gall writes: }> }> }> Hi Colin! }> }> We have OnLine 5.05.UC1 (on Digital Unix 3.0B) and the SQL statement works }> correctly in DB-Access. Perhaps you should ensure your SQL script has been }> copied correctly nad the ones haven't been replaced by letter el's. }> }> If it is a bug, maybe it's platform specific. } }... } }> Best regards, }> Nigel } }-- } _____________________________________________________________________ } | Colin McGrath cmm@trac3000.ueci.com | } | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | } | Phila, PA, USA Standard Disclaimers Apply | } |___________________________________________________________________| } } } Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+