DELETE FROM 表名 WHERE datediff(MM, AddTime,GETDATE()) > 1 DELETE FROM 表名 WHERE datediff(MM, AddTime,GETDATE()) > 3 DELETE FROM 表名 WHERE datediff(MM, AddTime,GETDATE()) > 6 DELETE FROM 表名 WHERE datediff(YY, AddTime,GETDATE()) > 1??
DELETE FROM 表名 WHERE datediff(month, AddTime,GETDATE()) >6
datediff(mm,..) datediff(yy,...)
1年 datediff(yy, AddTime,GETDATE()) >1
DELETE FROM 表名 WHERE datediff(mm, AddTime,GETDATE()) > 3 DELETE FROM 表名 WHERE datediff(mm, AddTime,GETDATE()) > 6 DELETE FROM 表名 WHERE datediff(year, AddTime,GETDATE()) >1
datediff(mm, AddTime,GETDATE()) >1
DELETE FROM 表名 WHERE datediff(MM, AddTime,GETDATE()) > 3
DELETE FROM 表名 WHERE datediff(MM, AddTime,GETDATE()) > 6
DELETE FROM 表名 WHERE datediff(YY, AddTime,GETDATE()) > 1??
datediff(yy,...)
datediff(yy, AddTime,GETDATE()) >1
DELETE FROM 表名 WHERE datediff(mm, AddTime,GETDATE()) > 6
DELETE FROM 表名 WHERE datediff(year, AddTime,GETDATE()) >1