postgresql查询把时间转换为年月日，按照天统计总数和获取率

SELECT
        to_char(to_timestamp(1628088734000/1000), ;yyyy-mm-dd;)AS DATE,
        COUNT(1) AS count,
        COUNT(1) / 2880 AS rate
FROM
        test h 

我的应用;

SELECT
        to_char(to_timestamp(1628088734000/1000), ;yyyy-mm-dd;)AS DATE,
        COUNT(1) AS count,
        COUNT(1) / 2880 AS rate
FROM
        test h 
WHERE
h.At >=;1633311150000; and h.At <=;1633311270000;
GROUP BY
      DATE
ORDER BY h.At DESC;