DATEDIFF(DAY, A.CreateTime, @StartTime) <= 0 AND DATEDIFF(DAY, A.CreateTime, @EndTime) >= 0 转载于:https://www.cnblogs.com/prayforsmile/archive/2010/06/11/1756392.html