22,209
社区成员
发帖
与我相关
我的任务
分享
select policyno,riskno,startdate,enddate
from prpcmian
where convert(varchar(10),startdate,120) between '2007-01-01' and '2007-01-31'
select policyno,riskno,startdate,enddate
from prpcmian
where startdate between '2007-01-01' and '2007-01-31'
select policyno,riskno,startdate,enddate
from prpcmian
where startdate between '2007-1-1' and '2007-1-31'