Select
EXTRACT(year from cast(joindate as timestamp)) as Year,
EXTRACT(month from cast(joindate as timestamp)) as Month,
EXTRACT(day from cast(joindate as timestamp)) as Day,
......
From Table
Group by Year,Month,Day
PostgreSQL按年月日分组
关于分享和转载：本文是由作者本人原创,如需分享或转载请备注原文出处！