select EXTRACT (week FROM timestamp '2022-01-07')
SELECT date_part('week',TIMESTAMP '2022-01-11') a, -- 获取周
pg按日,周,月进行数据统计
SELECT date_trunc('WEEK', insert_time
select EXTRACT (week FROM timestamp '2022-01-07')
SELECT date_part('week',TIMESTAMP '2022-01-11') a, -- 获取周
pg按日,周,月进行数据统计
SELECT date_trunc('WEEK', insert_time