On Saturday, 2. March 2002 12:10, Jamil Ahmed wrote: > is this a mysql Bug ? > > curdate()-3 returns 20020299 > curdate()-2 returns 20020300
No it's not a bug! But why do you want substract numbers from a string?! In this case 2002-03-02 will be interpreted as 20020302 and from this number you substract. When dealing with dates use the Date/Timefunctions described in the Manual. Regards Georg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php