ibatis中如何直接读取db2数据库中的当前时间？

[煎饼灬果子]

遇到一个问题，求大神指点，IS_SIGN为是否签约，为1是签约，要取系统当前时间，为0未签约，也是取系统当前时间，代码如下：
sql代码：
<update id="updateAgree" parameterType="Agree">
UPDATE TBL_SAC_UAGR

<set>
CODE = #{code,jdbcType=VARCHAR},
IS_SIGN = #{isSign,jdbcType=SMALLINT},
<if test="isSign != null and isSign!='' and isSign==1 ">
SIGN_TIME = CURRENT DATE
</if>
<if test="isSign != null and isSign!='' and isSign==0 ">
UNSIGN_TIME = #{unSignTime,jdbcType=TIMESTAMP}
</if>
</set>

where USER_ID = #{userId,jdbcType=BIGINT}
</update>


service代码：
public class AgreeService implements IAgreeService{

@Autowired
AgreeDao AgreeDao;

@Override
public List<Agree> findAgrees(Agree agree) {
return AgreeDao.findAgrees(agree);
}

@Override
public int updateAgree(Long userId , String code , String isSign) {
Agree agree = new Agree();
agree.setUserId(userId);
agree.setCode(code);
agree.setIsSign(isSign);
Date date = new Date();
Timestamp now = new Timestamp(date.getTime());
if("0".equals(isSign)){

agree.setUnSignTime(now);
}else{

agree.setSignTime(now);
}

return AgreeDao.updateAgree(agree);
}

求解答，分全给！！！！！！！！！！！！！！！！

[feixiaohuijava]

直接用now()不可以吗？