如果日期列有时间戳,如何按月对列进行计数?

select extract(month from date) as month, count(*) 
from t
group by extract(month from date);

month() extract()

select DATE_PART('month', date) as month,count(id) from yourtable
group by DATE_PART('Month', date)