34,587
社区成员
发帖
与我相关
我的任务
分享
declare @dt datetime
set @dt='2008-05-05'
select cast(convert(varchar(7),dateadd(month,-2,@dt),120)+'-26' as datetime),cast(convert(varchar(7),dateadd(month,-1,@dt),120)+'-25' as datetime)
----------------------- -----------------------
2008-03-26 00:00:00.000 2008-04-25 00:00:00.000
(1 行受影响)
declare @date datetime
set @date = '2008-05-05'
select dateadd(month,-2,@date)-day(@date)+26, dateadd(month,-1,@date)-day(@date)+25