返回2004-10 月分以来的所有帖子 ，怎么写SQL 语句？？

Question

select * from tablename where convert(char(7),datecol,120)='2004-10'

Answer 1

select * from tablename where convert(char(7),datecol,120)<='2004-10'

Answer 2

Select * from 表 Where DateDiff(d,'2004-10-01',字段)>0

Answer 3

select * from tablename where datediff(m,datecol,'2004-10-1')<=0

Answer 4

这样也可以Select * from 表 Where Convert(varchar(7),字段,120)>='2004-10'

Answer 5

select * from tablename where convert(char(7),datecol,120>='2004-10-01'

Answer 6

select * from tablename where (cast(year(Datatime) as varchar)+
+'-'+cast(month(Datatime) as varchar))='2004-10'