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;