Query 中设置时间问题？

Question

求大神解答，谢谢！
public void Update2(int i,int u) {
// TODO Auto-generated method stub
Session session = getSession();
Transaction trans=session.beginTransaction();
String hql="update UserInfo set state = 0 and alterId = ? and alterTime = ? where userId = ?";
Query queryupdate=session.createQuery(hql);
queryupdate.setLong(0, u);
queryupdate.setTimestamp(1, new Date());
queryupdate.setLong(2, i);
int ret=queryupdate.executeUpdate();
trans.commit();
}

报错是：java.lang.IllegalArgumentException: node to traverse cannot be null!

在线等啊！！！

Answer 1

SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
to_date('"+date.format(new Date())+"','yyyy/MM/dd HH24:mi:ss')