Similar queries gives different results

[Mucahit Celikag]

Hi,

I am using mysql running under solaris.

I am giving two similar queries and geting different results.
I couldn't find the solution to this problem. 

Example. 

Q1.    SELECT username,acctstatrtime,acctstoptime 
         FROM radacct 
         WHERE acctstarttime > '2001060112000000';

         ( Connections to internet after 12:00 - 01/06/2001 )

         Result of Q1
         username        acctstarttime                    acctstoptime           
         jon                   2001-06-01 12:01:00          2001-06-01 12:10:02
         mike                2001-06-01 13:02:00          2001-06-01 13:15:07
         simon              2001-06-01 13:06:06          0000-00-00 00:00:00

Q2.    SELECT username,acctstatrtime,acctstoptime  
          FROM radacct 
          WHERE username = 'jon' order by acctstatrtime asc;
 
          ( Connections of "jon" up to now. )

         Result of Q2
 
         No result or the list of connections made before  the above date.
         Does not show the above connection. 
 
         But I know in the first query there is connection.
 
         How can it be ? Can anyone help me ?
 

Thanks 

Mucahit Celikag