is this a mysql Bug ? curdate()-3 returns 20020299 curdate()-2 returns 20020300
Keep smiling, ;^) ~Jamil ********************************************************* mysql> select curdate(); +------------+ | curdate() | +------------+ | 2002-03-02 | +------------+ 1 row in set (0.00 sec) mysql> select curdate()-1; +-------------+ | curdate()-1 | +-------------+ | 20020301 | +-------------+ 1 row in set (0.00 sec) mysql> select curdate()-2; +-------------+ | curdate()-2 | +-------------+ | 20020300 | +-------------+ 1 row in set (0.00 sec) mysql> select curdate()-3; +-------------+ | curdate()-3 | +-------------+ | 20020299 | +-------------+ 1 row in set (0.00 sec) mysql> ********************************************************* --------------------------------------------------------------------- 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
