I am a tad confuse with this problem so any help would be greatly appreciated. When I run a query like this

SELECT *
FROM windowevents2 where ComputerName = 'LAB01'

I will only get result for Feb 10 2004, but if I query for a specific date such as

SELECT *
FROM windowevents2 where ComputerName = 'CITY06' and
Datetime = 'Fri Feb 13 13:10:03 2004'

I would get result for that date. Is there a reason why when querry just by ComputerName force mysql to returns only data for only Feb 10 2004? Thanks

What data type do you use on Datetime col ?

I am using varchar as the data type for DateTime