近一周的停车记录查询统计

SELECT DATE_FORMAT(create_time, '%Y-%m-%d') clickDate,
       count(*)                             count
FROM c_parking_order
WHERE parklot_id = #{parklotId}
  AND create_time >= DATE_SUB(CURDATE(), INTERVAL 6 DAY)
  and parking_status = 4
GROUP BY DATE_FORMAT(create_time, '%Y-%m-%d')
ORDER BY DATE_FORMAT(create_time, '%Y-%m-%d')

查询当天的停车记录                

  select count(1) from c_parking_order
        where create_time >= DATE_FORMAT(now(),'%Y-%m-%d')