ASP如何对日期型字段进行模糊查询?
pusy 2003-10-15 08:10:43 在sql server 2000 数据库
Add_DateTime--smalldatetime
select * from ReceiveLog where cstr(Add_DateTime) like '%"&xsj&"%'
查找不到记录!!!
我用
select * from ReceiveLog where cast(Add_DateTime as varchar(20))
like '%"&xsj&"%'
查找不到记录!!!