select
*
from
tb
where
convert
(
varchar
(7),
date
,120) =
'2011-05'
select
*
from
tb
where
convert
(
varchar
(7),
date
,120) =
'2011-05'
转载于:https://www.cnblogs.com/yangwujun/p/8876301.html