pgsql按周统计，想统计每周的周一到周日的数据。但是目前的sql虽然日期是周一到下周一但是统计值却是周日到下周六的数据 该如何调整？ 目前的sql select to_char("date"::DATE-(extract(dow from "date"::TIMESTAMP)-1||'day')::interval,'yyyy-mm-dd') "date" ,sum(qty) from "kpi_merge"."a0_cus_demand" where reserve1='V20210910' group by to_char("date"::DATE-(extract(dow from "date"::TIMESTAMP)-1||'day')::interval,'yyyy-mm-dd') --order by "date" |
1min目标场景问卷
立即参与
