declare @time intselect @time = 20090701select @time = substring(cast(dateadd(Day,-1,convert(varchar,@time,112)) as varchar(20)),7,4) + substring(cast(dateadd(Day,-1,convert(varchar,@time,112)) as varchar(20)),1,2) + substring(cast(dateadd(Day,-1,convert(varchar,@time,112)) as varchar(20)),4,2)print Read More
