PostgreSQL实现按年、月、日、周、时、分、秒的分组统计

按年查询

select to_char(date::DATE, ‘YYYY’) as year,sum(shares) as shares, sum(visits) as visits
from database_table
where date >= ‘2019-01-01’ and date <= ‘2020-01-01’ group by year order by year