sql - 查看 SQL - 减去日期

Question

我有以下看法

CREATE VIEW dbo.vw_IssueDates AS 
SELECT UserId,
       IssueDate

FROM users 
WHERE IssueDATE <= CONVERT(DATE,  '2015-01-20')
GO
SELECT * FROM dbo.vw_IssueDates

我正在尝试列出被罚款超过 30 天的用户，我知道它将动态涉及 GETDATE(所以是今天的日期)并减去 30，但不确定从哪里开始？

Answer 1

使用 DATEADD(day,-30,GETDATE())

SELECT UserId, IssueDate
FROM users
WHERE IssueDate >= DATEADD(day,-30,GETDATE())

另外，如果你想在一列中显示逾期天数..

SELECT UserId, IssueDate, DATEDIFF(day,IssueDate,GETDATE()) AS DaysOverDue
FROM users
WHERE IssueDate >= DATEADD(day,-30,GETDATE())