My guess is because 20040000000000 is an illegal time. If you try a legal time, January 1, midnight (20040101000000) it should work. You can also convert the time to integer and then compare values.
select last from users where last > 20040101000000 select last from users where cast(last as SIGNED) > 20040000000000 Ed -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] There must be a simple reason for this, but I am really stumped. Look at this: mysql> select last from users where last > 20040000000000 limit 10; +----------------+ | last | +----------------+ | 20040426191837 | | 20040504191410 | | 20040430170916 | | 20040424005350 | | 20040504192210 | | 20040503210716 | | 20040502235436 | | 20031218112740 | <-------- NOTICE THIS ONE | 20040504210456 | | 20040503190616 | +----------------+ 10 rows in set (0.00 sec) ********************** Notice there is a 2003 (14-digit) timestamp included even though I queried the database for just timestamps greater than 20040000000000 (14 digits). I am stumped. Can anyone tell me the simple reason why this is not working right? Thanks Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
