where datediff(month,datecolumn,convert(datetime,'2008-09-30'))>=0
select * from tb where dt < '2008-09-01' select * from tb where dt < '2008-10-01'select sum(...) from tb where dt < '2008-09-01' select sum(...) from tb where dt < '2008-10-01'
declare @t varchar(10) set @t ='2008-09' select * from 表名 where 日期<cast(@t+'-01' as datetime)
select* from table where diffdate(table.mm,2008-9)<0
select * from tb where dt <= '2008-08-31'
select * from tb where convert(varchar(7),dt,120)<'2008-09'
select * from tb where dt < '2008-10-01'select sum(...) from tb where dt < '2008-09-01'
select sum(...) from tb where dt < '2008-10-01'
declare @t varchar(10)
set @t ='2008-09'
select * from 表名 where 日期<cast(@t+'-01' as datetime)
select * from tb where convert(varchar(7),dt,120)<'2008-09'