22,209
社区成员
发帖
与我相关
我的任务
分享
declare @beginDate datetime
declare @endDate datetime
set @beginDate = dateadd(month,-3,getdate()-day(getdate())+1)
set @endDate = dateadd(day,0,getdate()-day(getdate()))
select @beginDate as [起始时间],@endDate as [结束时间]
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([testdate] Date,[test] int)
Insert #T
select '2017-01-01',1 union all
select '2017-02-01',2 union all
select '2017-03-01',3 union all
select '2017-04-01',4 union all
select '2017-05-01',5
Go
--测试数据结束
SELECT *
FROM #T
WHERE DATEDIFF(MONTH, testdate, GETDATE()) <> 0
AND DATEDIFF(MONTH, testdate, GETDATE()) < 4