Andrew, Wednesday, November 06, 2002, 7:39:16 PM, you wrote: AS> SELECT ... FROM table o WHERE o.date >= 20020901000000 AND o.date<=20021106240000
AS> MySQL 3.23.xx - work (returns >0 rows) AS> MySQL 4.0.4 - not work (returns 0 rows) AS> P.S. also in 4.0.4 not work BETWEEN in this case (but as i can AS> see it will be fixed in next release) Hi! Thank you for bug report! Seems, it also was fixed in 4.0.5. Could you test it at the next week on 4.0.5? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
