SELECT * FROM TB WHERE DATEPART(Q,GETDATE())= DATEPART(Q,date1)
IF(DATEPART(MM,[TTIME])%3=0) SELECT * FROM TB WHERE [TTIME] BETWEEN DATEADD(MM,-2,[TIME]) AND [TIME] IF(DATEPART(MM,[TTIME])%3=1) SELECT * FROM TB WHERE [TTIME] BETWEEN DATEADD(MM,2,[TIME]) AND [TIME] IF(DATEPART(MM,[TTIME])%3=2) SELECT * FROM TB WHERE [TTIME] BETWEEN DATEADD(MM,-1,[TIME]) AND DATEADD(MM,1,[TIME])
SELECT * FROM TB WHERE DATEPART(Q,GETDATE())= DATEPART(Q,date1) And year(getdate())=year(date1) 需要年份相同吗?
FROM TB
WHERE DATEPART(Q,GETDATE())= DATEPART(Q,date1)
SELECT * FROM TB WHERE [TTIME] BETWEEN DATEADD(MM,-2,[TIME]) AND [TIME]
IF(DATEPART(MM,[TTIME])%3=1)
SELECT * FROM TB WHERE [TTIME] BETWEEN DATEADD(MM,2,[TIME]) AND [TIME]
IF(DATEPART(MM,[TTIME])%3=2)
SELECT * FROM TB WHERE [TTIME] BETWEEN DATEADD(MM,-1,[TIME]) AND DATEADD(MM,1,[TIME])
FROM TB
WHERE DATEPART(Q,GETDATE())= DATEPART(Q,date1)
And year(getdate())=year(date1)
需要年份相同吗?