记录一下,实操过。。。
时间戳格式
FROM_UNIXTIME(create_time,'%Y-%m-%d') as time
日期格式
DATE_FORMAT(create_time,'%Y-%m-%d') as time
查询每一条插入的条数,每天:
SELECT FROM_UNIXTIME(create_time,'%Y-%m-%d') as time , count(*) as count FROM 表名 where 条件 GROUP BY time
结果: