34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM TBL_BorrowInfo
WHERE DATEDIFF(dd,(DATEADD("m",1,BorrowDate),111)),GETDATE()) > 0
SELECT * FROM TBL_BorrowInfo
WHERE DATEDIFF(dd,DATEADD(m,1,BorrowDate),GETDATE()) > 0
SELECT * FROM TBL_BorrowInfo
WHERE DATEDIFF(mm,BorrowDate,GETDATE()) > 1
or (DATEDIFF(mm,BorrowDate,GETDATE()) = 1 and right(convert(varchar(10),BorrowDate,120),5) < right(convert(varchar(10),GETDATE(),120),5))
SELECT * FROM TBL_BorrowInfo
WHERE DATEDIFF(dd,(DATEADD(m,1,LastUpdateDate)),GETDATE()) > 0