34,838
社区成员




declare @s char(6)
declare @date char(10)
declare @dt datetime
set @s='200712'
set @date=left(@s,4)+'-'+right(@s,2)+'-01'
set @dt=dateadd(month,-1,cast(@date as datetime))
set @s=left(convert(char(10),@dt,120),4)+substring(convert(char(10),@dt,120),6,2)
select @s
/*
------
200711
*/