- 按时间分组
SELECT FROM_UNIXTIME(add_time,'%Y-%m-%d') AS date FROM pinty_order where order_status
in (201,301,300,302,302,401) GROUP BY FROM_UNIXTIME(add_time,'%Y-%m-%d') ORDER BY date ASC;
如果add_time 为时间戳,需要add_time/1000
FROM_UNIXTIME( unix_timestamp ,format ) 将unix时间戳转时间格式字符串
UNIX_TIMESTAMP( da