使用INTERVAL它的类型。例如：
--yesterday
SELECT Now() - INTERVAL '1 DAY';
--Unrelated to the question, but Postgresql also supports some shortcuts:
SELECT 'yesterday'::TIMESTAMP, 'tomorrow'::TIMESTAMP, 'allballs'::TIME;
然后，您可以对查询执行以下操作：
SELECT
org_id,
count(accounts) AS COUNT,
((date_at) - INTERVAL '1 DAY') AS dateat
FROM
sourcetable
WHERE
date_at <= Now() - INTERVAL '130 DAYS'
GROUP BY
org_id,
dateat;
602392714
清零编程群