Date comparation problem

[Bogdan Gusiev]

Hi All,

I have met the following problem with one of my MySQL DB instance:

mysql> select jobcreationdate from job where date(jobcreationdate) = '2008-01-21'
-> ;
Empty set (0.00 sec)

mysql> select jobcreationdate from job where jobid = 50
-> ;
+---------------------+
| jobcreationdate |
+---------------------+
| 2008-01-21 06:11:37 |
+---------------------+
1 row in set (0.00 sec)

mysql>

Does anybody know where the problem is?



Edited 1 time(s). Last edit at 04/30/2008 06:53AM by Bogdan Gusiev.