1 --日期运算 2 (DATEDIFF ( DAY , tblW.CreatTime , GETDATE() ) <=tblW.Effective 1 --日期格式化2 CONVERT(VARCHAR(20),A.addTime,120) as 添加时间3 --报错日志表4 select * from LogDB.DBO.SysProErrLogTbl order by id desc5 --隐藏字符6 stuff(A.UUID,8,20,'**********') AS 设备码
1 --日期运算 (DATEDIFF ( DAY , tblW.CreatTime , GETDATE() ) <=tblW.Effective