mysql 查询时间,可以精确到秒
精确到天 SELECT DATE_FORMAT(create_time, '%Y-%m-%d') AS time, COUNT(*) AS num FROM customer WHERE customer_phone > 17862462917 GROUP BY time WITH ROLLUPORDER BY time;精确到小时 SELECT DATE_FORMAT(create_time, '%Y-%m-%d %H') AS time, COUNT(*) AS num
原创
2020-08-05 10:05:06 ·
3094 阅读 ·
0 评论