hql时间比较

  /**
     * 获取现在时间
     *
     * @return 返回时间类型 yyyy-MM-dd HH:mm:ss
     */
     public static java.sql.Timestamp getNowSqlDate() {
     Date currentTime = new Date();
     SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
     String dateString = formatter.format(currentTime);
     java.sql.Timestamp currentTime_2 = java.sql.Timestamp.valueOf(dateString);
     return currentTime_2;
     }

返回24时制当前时间yyyy-MM-dd HH:mm:ss 如果yyyy-MM-dd hh:mm:ss则返回12时制的当前时间

hql代码

Map filterMap1=new HashMap();         
filterMap1.put("kcjyid", kcjy.getId().toString());
filterMap1.put("nowtime", DateUtil.getNowSqlDate());

Collection<Object> teachksaplist=(Collection<Object>) serviceFactory.getAdminService().list1("from Ksap as b where b.kcjyId=:kcjyid and b.ksend <:nowtime order by b.ksend ", page, 1, filterMap1);

ksend 为Ksap 实体中的属性类型为Date