HQL当前时间与Mysql数据库时间比较

public List<miniActivityRecord> getActivityRecordList(int pageNumber) {
// 查询语句HQL构建
StringBuffer sql = new StringBuffer();
sql.append(" select new com.clothes.query.pojo.miniActivityRecord (id,activityName,activityContent,activityType,beginTime,endTime,total,remarks)");
sql.append(" from ActivityRecord ar where ar.isValid=1 and ar.endTime>now()");
sql.append(" order by beginTime");
Session session = this.getHibernateTemplate().getSessionFactory()
.getCurrentSession();
Query query = session.createQuery(sql.toString());
query.setCacheMode(CacheMode.IGNORE);
query.setCacheable(false);
query.setFirstResult((pageNumber - 1)
* CommonConstant.PAGE_ROW_TWENTY_SIZE); // 第一个显示结果
query.setMaxResults(CommonConstant.PAGE_ROW_TWENTY_SIZE);// 显示的结果集长度
@SuppressWarnings("unchecked")
List<miniActivityRecord> list = (List<miniActivityRecord>) query.list();
return list;
}