MyBatis--------查询7天内的记录

MySQL

        SELECT count(1) FROM ${sourceTable}
        WHERE
        1=1
        AND ${createTime} >= DATE_SUB(NOW(),INTERVAL 7 DAY)

Oracle

        SELECT count(1) FROM ${sourceTable}
        WHERE
        1=1
        AND ${createTime} >= sysdate - 7