--常用的做法, 会漏掉 类似 BeginDateTime = '2011-11-30 23:59:00' 的记录 SELECT COUNT(*) FROM Appointment a WHERE a.BeginDateTime BETWEEN '11/1/2011' AND '11/30/2011' --推荐做法 SELECT COUNT(*) FROM Appointment a WHERE DATEDIFF(DAY, '11/1/2011', a.BeginDateTime) >= 0 AND DATEDIFF(DAY, '11/30/2011', a.BeginDateTime) <= 0
SQL - 取两日期之间的记录, 最好是用 DATEDIFF 而不是 Between
最新推荐文章于 2021-02-22 02:47:00 发布