Mysql语句转换为Mybatis语句？

Question

这是Mysql语句： select date_format(ordertime,'%Y-%m-%d') as 日期, count(1) as 数量 from v_order where ordertime >= date(now()) - interval 7 day group by day(ordertime)如何转换为Mybatis语句，求！

Answer 1

在mybatis的xml文件里把>= 写成>= 就可以了>就表示大于号

SELECT
    date_format(ordertime, '%Y-%m-%d') AS 日期,
    count(1) AS 数量
FROM
    v_order
WHERE
    ordertime >= date(now()) - INTERVAL 7 DAY
GROUP BY
    DAY (ordertime)