MySQL 时间戳按天分组

分类：MySql 发布时间：2021-04-18 15:19:56

``` SELECT FROM_UNIXTIME(order_time,'%Y-%m-%d')AS DATE,COUNT(*) FROM orders WHERE order_status=1 GROUP BY FROM_UNIXTIME(order_time,'%Y-%m-%d'); ```