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
原文：http://www.cnblogs.com/Ryan2012/p/6641649.html