设置某个时间为当前时间的两天之后
<insert id="insert" useGeneratedKeys="true" keyProperty="id" parameterType="cn.hctech2006.umbrella.bean.Order">
insert into hc_umbrella.order ( order_id, stu_id,stu_name, um_id, status, stu_class
, stu_phone, begin_time, end_time, station_id,renew_status,renew_time)
values ( #{orderId,jdbcType=VARCHAR}, #{stuId,jdbcType=VARCHAR},
#{stuName,jdbcType=VARCHAR}, #{umId,jdbcType=VARCHAR}, 0,
#{stuClass,jdbcType=VARCHAR}, #{stuPhone,jdbcType=VARCHAR}, now(),
now(),#{stationId,jdbcType=VARCHAR},0, DATE_ADD(now(), INTERVAL 2 DAY) )
</insert>
其中DATE_ADD(now(), INTERVAL 2 DAY)
表示使得当前时间加两天
语法
https://www.w3school.com.cn/sql/func_date_add.asp