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 : sitnikov@infonet.ee
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: DateTime comparation problems

Try using dashes.

yyyy-mm-dd

-----Original Message-----
From: Andrew Sitnikov [mailto:sitnikov@infonet.ee]
Sent: Wednesday, November 06, 2002 9:39 AM
To: bugs@lists.mysql.com
Cc: mysql@lists.mysql.com
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 : sitnikov@infonet.ee
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
To unsubscribe, e-mail

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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: DateTime comparation problems

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
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ 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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php