select * from tb where indatetime between '2004-5-25' and '2004-5-26'
select * from tb where '2004-5-25'=convert(varchar(10),indatetime,20)
select * from tb where '2004-5-25'=convert(varchar(10),indatetime,20)
where indatetime='2004-5-25'
------------------
如果你想找出比重复的行
在前面加个关键字OK 了
select distinct indatetome from table_name
where indatetime='2004-5-25'