-- ɾ³ý6¸öÔÂ֮ǰµÄPCSϵͳÈÕÖ¾Êý¾Ý
DECLARE @MonthsAgo INT = 6;
DECLARE @CurrentDate DATE = GETDATE();
DECLARE @CutOffDate DATE = DATEADD(MONTH, -@MonthsAgo, @CurrentDate);
 
-- ɾ³ý²Ù×÷
DELETE FROM dt_log_pcs
WHERE [createtime ] < @CutOffDate;