2007-11-21 SQL select count(*) , SUBSTRING(create_date,1,10) from account where is_delete=0 GROUP BY SUBSTRING(create_date,1,10);