比较SQL Server中的日期(Comparing dates in SQL Server)

比较SQL Server中的日期(Comparing dates in SQL Server)

我有一个名为EXP_Date的DateTime列，其中包含如下日期：

2014-07-13 00:00:00.000

我想比较它们，比如这个查询：

SELECT COUNT(*) FROM DB WHERE ('2014-07-15' - EXP_DATE) > 1

我希望看到服务过期超过一个月的客户数量。

我知道这个查询不会给我正确的答案，最好的方法是如果我将年/月/日分成三列，但是没有任何其他方式来比较它们，因为它们是什么？

I have a DateTime column named EXP_Date which contains date like this :

2014-07-13 00:00:00.000

I want to compare them, like this query :

SELECT COUNT(*) FROM DB WHERE ('2014-07-15' - EXP_DATE) > 1

I expect to see the number of customers who have their services expired for over a month.

I know this query wouldn't give me the correct answer, the best way was if I separate the Year / Month / Day into three columns, but isn't any other way to compare them as they are?

最满意答案

您可以使用DATEADD

SELECT COUNT(*) FROM DB where EXP_DATE < DATEADD(month, -1, GETDATE())

You can use DATEADD

SELECT COUNT(*) FROM DB where EXP_DATE < DATEADD(month, -1, GETDATE())