select DATE_FORMAT(FROM_UNIXTIME(add_date),’%Y-%m-%d’) as day,count(*) from tbkt_task.yw_task_practice_test group by day limit 100
sql时间戳按照天统计数据
最新推荐文章于 2024-02-01 16:07:01 发布
select DATE_FORMAT(FROM_UNIXTIME(add_date),’%Y-%m-%d’) as day,count(*) from tbkt_task.yw_task_practice_test group by day limit 100