SELECT DATE_FORMAT(table_feild, '%Y-%m-%d %T:%f') AS time, COUNT(*) AS num
FROM customer
WHERE table_feild > 17862462917
GROUP BY time
WITH ROLLUP //统计总数
ORDER BY time;
重点为:
'%Y-%m-%d %T:%f'
SELECT DATE_FORMAT(table_feild, '%Y-%m-%d %T:%f') AS time, COUNT(*) AS num
FROM customer
WHERE table_feild > 17862462917
GROUP BY time
WITH ROLLUP //统计总数
ORDER BY time;
重点为:
'%Y-%m-%d %T:%f'