27,579
社区成员
发帖
与我相关
我的任务
分享
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([STime] datetime,[Ftime] datetime)
insert [tb]
select '2008-1-1','2008-7-31' union all
select '2008-8-1','2008-11-30'
update tb
set Ftime=dateadd(d,-1,dateadd(yy,datediff(yy,0,Ftime)+1,0))
where month(STime)>7
select * from [tb]
--测试结果:
/*
STime Ftime
----------------------- -----------------------
2008-01-01 00:00:00.000 2008-07-31 00:00:00.000
2008-08-01 00:00:00.000 2008-12-31 00:00:00.000
(2 行受影响)
*/