select * from yourtbl where format(datefield, 'yyyy-mm')='2003-02'
select * from 表 where convert(char(10),日期,102) like "2003.03.%"
qqqdong() 的方法最简单,但是你取来的变量要组成这种格式2003.02 select * from yourtable where convert(char(10),datefield,102) like '2003.02.%' 如记不住convert转换函数的时间样式如102等,可用如下方式. select * from yourtable where year(datefield)=left('2003-02',4) and month(datefield)=right('2003-02',2)
select * from yourtable where convert(char(10),datefield,102) like '2003.02.%'
如记不住convert转换函数的时间样式如102等,可用如下方式.
select * from yourtable where year(datefield)=left('2003-02',4) and month(datefield)=right('2003-02',2)