81,092
社区成员
发帖
与我相关
我的任务
分享
select * from student where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(CREATETIME)
,现在改成参数是一个int类型的参数intervalDay,请问如何修改?我写成下面的语句,编译错完了.
<!-- pd is hasmap type -->
<select id="selectstudentresult" parameterType="page" resultType="pd">
select * from student
<where>
<if test="pd.intervalDay!=null">
and DATE_SUB(CURDATE(), INTERVAL ${pd.intervalDay} DAY) <= date(a.UPDATETIME)
</if>
</where>