mysql version 3.23.50
Field kwData_wydania is of type date. As you can see, dates are different that
expected. Is this a bug?
Select ksiazka_wyd.kwId,kwData_wydania
-> from ksiazka_wyd
-> LEFT JOIN serie ON ksiazka_wyd.srId=serie.srId and
-> kwData_Wydania
-> between '2002-07-01' and '2002-07-31'
-> limit 5;
+------+----------------+
| kwId | kwData_wydania |
+------+----------------+
| 241 | 1998-01-01 |
| 242 | 1998-04-12 |
| 243 | 1996-01-01 |
| 245 | 1993-01-01 |
| 247 | 0000-00-00 |
+------+----------------+
5 rows in set (0.00 sec)
TIA
Rafal
table,query
---------------------------------------------------------------------
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
