mysql 时间转换成日期
很多时候都存了当前时间,没有单独存日期这个函数。查询按天查询的时候,需要转换成日期。
select DATE_FORMAT(create_time, "%Y-%m-%d") as day, count(DISTINCT(product_user_id)) as uv, count(product_user_id) as pv from dts_pay_order where client_id = 32 and create_time > '2023-03-01' and create_time < '2023-04-01' GROUP BY DATE_FORMAT(create_time, "%Y-%m-%d") ORDER BY create_time;