regarding: >>2006/03/31 minus 1 month : I could accept 28 Feb or 1 Mar as a reasonable answer and I can make that point to my users.
>>03 March is not reasonable, I can't think of any logic that would give me that answer and I'm not able to make any case. I believe the logic used is to subtract one from the month of 2006-March and obtain 2006-February, and use the same date of "31". "2006/02/31" is then interpreted to mean "the date 3 days following 2006/02/28, or 2006/03/03" -- just as one might consider it reasonable when presented with "april 31st" to interpret it as "May 1st". I agree it's considerably more odd in the first case, but since "subtracting x months" has no standardized meaning, everything depends upon the specific use. What will the end use be for the subtracted date? If it's necessary to perform the date manipulation in SQL, and if you can't use the existing logic, you could integrate your own date routines, perhaps drawing mostly from the existing code. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
