2012年3月17日
sql service 关于时间(datetime)加减计算例子
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
posted @ 2012-03-17 20:53 咸鱼公子 Views(8321) Comments(0) Diggs(0)