例如:select to_char(t.shrq,'yyyy-mm-dd'),count(*) from zd_qssp t where t.shrq is not null group by to_char(t.shrq,'yyyy-mm-dd')