My guess is because 200400 is an illegal time. If you try a
legal time, January 1, midnight (2004010100) it should work.
You can also convert the time to integer and then compare values.
select last from users where last > 2004010100
select last from users where cast(last as SIGNE
There must be a simple reason for this, but I am really stumped.
Look at this:
mysql> select last from users where last > 200400 limit 10;
++
| last |
++
| 20040426191837 |
| 20040504191410 |
| 20040430170916 |
| 20040424005350 |
| 20040504192210
