Andrew,
Wednesday, November 06, 2002, 7:39:16 PM, you wrote:
AS> SELECT ... FROM table o WHERE o.date >= 2002090100 AND o.date<=2002110624
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
Try using dashes.
-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
Hello bugs,
SELECT ... FROM table o WHERE o.date >= 2002090100 AND o.date<=2002110624
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,
Andr
