7,714
社区成员
发帖
与我相关
我的任务
分享
select * from tt where format(shijian,'yyyymm')='200907'
select * from tt where convert(varchar(7),shijian)='200907'
select * from yourTable where shijian between #2009-07-01# and #2009-07-31#
select * from yourTable where year(shijian)=2009 and month(shijian)=7;
select * from yourTable where year(shijian)*100+month(shijian)=200907
select * from yourTable where format(shijian,'yyyymm')='200709'