mysql 查询时间，可以精确到秒

最新推荐文章于 2025-03-07 21:22:53 发布

踏雪追风555

最新推荐文章于 2025-03-07 21:22:53 发布

阅读量3.3k

点赞数 3

分类专栏：时间查询文章标签： mysql

本文链接：https://blog.csdn.net/qq_27127363/article/details/107808099

版权

时间查询专栏收录该内容

1 篇文章

订阅专栏

精确到天

 SELECT DATE_FORMAT(create_time, '%Y-%m-%d') AS time, COUNT(*) AS num
 FROM customer
 WHERE customer_phone > 17862462917
 GROUP BY time
 WITH ROLLUP
ORDER BY time;

精确到小时

 SELECT DATE_FORMAT(create_time, '%Y-%m-%d %H') AS time, COUNT(*) AS num
 FROM customer
 WHERE customer_phone > 17862462917
 GROUP BY time
 WITH ROLLUP
ORDER BY time;

精确到分钟

 SELECT DATE_FORMAT(create_time, '%Y-%m-%d %H:%i') AS time, COUNT(*) AS num
 FROM customer
 WHERE customer_phone > 17862462917
 GROUP BY time
 WITH ROLLUP
ORDER BY time;

精确到秒

 SELECT DATE_FORMAT(create_time, '%Y-%m-%d %H:%i:%s') AS time, COUNT(*) AS num
 FROM customer
 WHERE customer_phone > 17862462917
 GROUP BY time
 WITH ROLLUP
ORDER BY time;