gistfile1.txt select count(id) as total from bill where 1 = 1 and 1 = 1 and 1 = 1 and createTime = date_sub('2017-11-30',interval -1 day)使用mysql日期处理函数将结束日期向后加到后一天00:00:00:000
select count(id) as total from bill where 1 = 1 and 1 = 1 and 1 = 1 and createTime <= date_sub('2017-11-30',interval -1 day)
使用mysql日期处理函数将结束日期向后加到后一天00:00:00:000