select count(*), to_char(t.input_time, 'yyyy-mm-dd') time from news_info t group by to_char(t.input_time, 'yyyy-mm-dd') order by to_char(t.input_time, 'yyyy-mm-dd') asc nulls last 结果: