文章目录
1create_time在数据库中是datetime类型
1.1传字符串
1.1.1方式一(转成同一类型)
Integer countTargetRewardSettleAccounts(
@Param(“startTime”) String startTime, @Param(“endTime”) String endTime);
SELECT
COUNT(*)
FROM target_reward_settle_accounts_daily
WHERE
<![CDATA[
create_time >= str_to_date( #{
startTime},'%Y-%m-%d %H:%i:%s')
AND create_time < str_to_date( #{
endTime},'%Y-%m-%d %H:%i:%s')
]]>
1.1.2方式二(转成同一类型)
<if test="beginTime!=null and beginTime!=''">
<![CDATA[ and DATE_FORMAT(tr.add_time, '%Y-%m-%d')>= DATE_FORMAT(#{
beginTime}, '%Y-%m-%d') ]]>
</if>
<if test=