sql中直接转换时间格式

例如

select DATE_FORMAT(oi.create_time ,'%Y-%m-%d') orderDate, sum(oi.total_amount)  totalAmount , count(oi.id) totalNum
from order_info oi where DATE_FORMAT(oi.create_time ,'%Y-%m-%d') = #{createTime}
GROUP BY DATE_FORMAT(oi.create_time ,'%Y-%m-%d')