VB6 And MS-SQL 2000 Not Like '00:00:00' In Datetime Column Question

Dears

I'd like to get the recordset of records that do NOT have the written value in datetime type column, for ex.


select * from my_data where its_data not like '%00:00:00%' and its_data >= '2005-05-10' and its_data <='2005-05-12'

or

select * from my_data where its_data not like '00:00:00' and its_data >= '2005-05-10' and its_data <='2005-05-12'

in such command I have all records also with (not desired) time 00:00:00 like 2005-05-11 00:00:00
Who knows the proper syntax?


Rgds