订单
id | order_id | created_atupdated_at1total_amount | |||
---|---|---|---|---|---|
1 | abc123 | 2021-06-13 11:00:00 | 2021:06-13 11:0:0 | 230.5||
2 | abc456 | 2021-06-01 07:00:00 | 202 1-06-01 07:00:00 | 240 |
为什么不直接使用日期比较?
select count(*) as num_purchases
from orders
where created_at >= current_date - interval '14 day'
只需从now()
(或为当前时刻提供正确时间的任何其他函数/变量(中减去相应的间隔,并将其与创建时间戳进行比较。大致如下:
SELECT count(*)
FROM orders
WHERE created_at >= now() - '14 days'::interval
AND created_at < now() - '7 days'::interval;