select dateadd(day,number,convert(varchar(7),dateadd(month,-3,getdate()),120)+'-01') from master..spt_values where type='p' and number>=0 and dateadd(day,number,convert(varchar(7),dateadd(month,-3,getdate()),120)+'-01')<convert(varchar(7),getdate(),120)+'-01'
但是我要获得当前时间的前三个月的时间 怎么写?
from master..spt_values
where type='p'
and number>=0
and dateadd(day,number,convert(varchar(7),dateadd(month,-3,getdate()),120)+'-01')<convert(varchar(7),getdate(),120)+'-01'