1、天
select to_char(create_time,'yyyy-mm-dd') as groupColunm from t_ group by groupColunm;
2、周
select to_char(create_time,'%Y-%U') as groupColunm from t_ group by groupColunm;
3、月
select to_char(create_time,'%Y-%m') as groupColunm from t_ group by groupColunm;