mysql 日期范围查询

 时间段查询

select
                    ifnull(l.num,0) as value,
                    temp.dd as time
                    from (
                    select
                    ifnull(count(1),0) as num
                    ,date_format(bdr.create_time,'%Y%m%d') as time
                    from bil_location_record bdr
                    <where>
                        id IN ( SELECT max( id ) FROM bil_location_record GROUP BY waybill_no )
                        AND retrieval_status = '0'
                        <if test="sites != null and sites.size() > 0">
                            and bdr.storage_outlets_code in <foreach item="siteCode" collection="sites" open="(" separator="," close=")">#{siteCode}</foreach>
                        </if>
                    </where>
                    GROUP BY  date_format(bdr.create_time,'%Y%m%d')
                    ) l right join
                    (
                    select DATE_FORMAT(DATE_ADD( #{timeStart}, INTERVAL @i:=@i+1 DAY ),'%Y%m%d') as dd from (
                    select 1
                    <foreach item="index" collection="countArr">
                        union all s