T-SQL時間條件查詢

SELECT COMID, COMDATE, COMMENT, COMNAME, MAGDATE, MANAGE, MAGNAME, CSTATUS

FROM COMMENTDATA

WHERE MANAGE IS NULL)
OR
(GETDATE() BETWEEN CONVERT(datetime, MAGDATE, 112) - 7
AND
CONVERT(datetime, MAGDATE, 112) + 7)