比较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.000I want to compare them, like this query :
SELECT COUNT(*) FROM DB WHERE ('2014-07-15' - EXP_DATE) > 1I 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())更多推荐
发布评论