~~~ select DATE_FORMAT(gmt_create, '%Y-%m-%d') as dt, count(*) as cnt from needle_pkg where gmt_create>= '2020-03-01' group by dt; ~~~