为什么date类型的不能like查询？

[会飞的小洋洋]

select * from tb where date like '2005%'

为什么不能查出日期中包含2005的字段?

[zzit0721]

select * from tb where convert(varchar,date)like '2005%'
这样应该可以

[点点星灯]

对时间是不允许用like

select * from tb where date datepart(year,时间字段)=2005

[20011521]

select *from UserTable where timeCreateDate like '%2003%'

[点点星灯]

--上面写错了，这个才是
select * from tb where datepart(year,时间字段)=2005

[superunusa]

select * from tb where convert(varchar(100),insert_time,21) like '2005%'

[churchatp1]

select * from tb where convert(varchar(10),date，120) like '2005%'

[会飞的小洋洋]

十分感谢各位！！！