Question

sql对关于时间的模糊查询（convert LIKE 等等）具体语句如下：

select count(*) from [FRU_PROJECT_DEMAND] where PRO_MISSION_NO LIKE Convert(varchar(10),getdate(),120)

假如今天是 2011-4-28 我想通过上述语句查询到2011-4-28当天一共有多少PRO_MISSION_NO

Answer 1

select count(*) from [FRU_PROJECT_DEMAND] where Convert(varchar(10),PRO_MISSION_NO,120) = Convert(varchar(10),getdate(),120)