22,206
社区成员
发帖
与我相关
我的任务
分享
set @dt='2010-03'
select * from tb
where CAST(@dt+'-01' as datetime)>=begindate
or CAST(@dt+'-01' as datetime)>=enddate
SELECT * FROM TB WHERE CONVERT(VARCHAR(7),BEGINTIME,120)<='2010-03'
AND CONVERT(VARCHAR(7),ENDTIME,120)>='2010-03'