27,580
社区成员
发帖
与我相关
我的任务
分享
Declare
@Date datetime,
@Date2 datetime,
@yuezong int,
@Yueshu int ,
@date3 datetime
Set @Date='20100506'
set @Date2=getdate()
set @Yuezong='10'
Select
@Yueshu=datediff(MM,@Date,@Date2 )
;
while(@Yueshu<@yuezong)
begin
select (cast(year(@Date2) as nvarchar(4))+'-'+ cast(month(@Date2) as nvarchar(2))+ '-'+ cast(day(@Date2) as nvarchar(2)))
set @Yueshu=@Yueshu +1
set @date2=dateadd(month,1, @date2)
end
declare @month int
set @month=6
select
convert(varchar(8),dateadd(dd,-1,convert(varchar(6),dateadd(mm,number,getdate()),112)+'01'),112)
from master..spt_values
where type='P'
and number between 1 and @month
/**
--------
20100831
20100930
20101031
20101130
20101231
20110131
(6 行受影响)
**/