Hello bugs, SELECT ... FROM table o WHERE o.date >= 20020901000000 AND o.date<=20021106240000
MySQL 3.23.xx - work (returns >0 rows) MySQL 4.0.4 - not work (returns 0 rows) P.S. also in 4.0.4 not work BETWEEN in this case (but as i can see it will be fixed in next release) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 --------------------------------------------------------------------- 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
