sql按天分组

sql按天分组，这都不会 晕！！！！！！！

select to_char(createtime,'yyyymmdd'),count(1) from os_user_config_0705 group by to_char(createtime,'yyyymmdd') order by 1;