SELECT DATE_FORMAT(FROM_UNIXTIME(addtime),"%Y-%m-%d") as day,count(*) as
visitnum FROM xxx
GROUP by DATE_FORMAT(FROM_UNIXTIME(addtime),"%Y-%m-
%d");
数据库查询时间戳(按时间分组)
最新推荐文章于 2024-01-13 18:36:07 发布
SELECT DATE_FORMAT(FROM_UNIXTIME(addtime),"%Y-%m-%d") as day,count(*) as
visitnum FROM xxx
GROUP by DATE_FORMAT(FROM_UNIXTIME(addtime),"%Y-%m-
%d");