Try using dashes. yyyy-mm-dd
-----Original Message----- From: Andrew Sitnikov [mailto:sitnikov@;infonet.ee] Sent: Wednesday, November 06, 2002 9:39 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: DateTime comparation problems 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 --------------------------------------------------------------------- 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
