DATEDIFF(day,#{rebaTimeStart},a.CreateTime)>=0 AND DATEDIFF(day,a.CreateTime,#{rebaTimeEnd} )>=0
day:以天比较
DATEDIFF(day,#{TimeStart},a.CreateTime)=1:
以天比较,
等于1:为CreateTime大于TimeStart
等于0:CreateTime等于TimeStart
等于-1:CreateTime小于TimeStart
DATEDIFF(day,#{rebaTimeStart},a.CreateTime)>=0 AND DATEDIFF(day,a.CreateTime,#{rebaTimeEnd} )>=0
day:以天比较
DATEDIFF(day,#{TimeStart},a.CreateTime)=1:
以天比较,
等于1:为CreateTime大于TimeStart
等于0:CreateTime等于TimeStart
等于-1:CreateTime小于TimeStart
转载于:https://my.oschina.net/u/3358860/blog/2050865