sql时间戳按天来分组

由于时间戳每一秒都不同，所以可以分组，但无法查询该字段，所以先转为天的格式来查看

SELECT
  count(*) AS counter,
  timedate
FROM
  (
    SELECT
      *,
      date_format(from_unixtime(c.addtime), '%Y-%m-%d') AS timedate
    FROM
      l_tour_member_order AS c
    where
      productautoid IN (30, 33, 35, 37, 38, 39, 484, 488, 494)
  ) as tmp
WHERE
  timedate >= '2021-07-16'
GROUP BY
  timedate

该订单表里addtime是时间戳，但要查询最近一个月每天订单多少，先查询该表信息并附加一个新字段timedate，整个查询数据作为附加表来查询，并按该字段分组