Hibernate查询以忽略时间戳的日期获取记录

String hql = "from POJO as POJO where to_date(to_char(POJO.tradeDate, 'DD-MON-YY'), 'DD-MON-YY') = :date"; Query query = getSession().createQuery(hql); query.setParameter("date", date);

[编辑]

请注意，

tradeDate

String hql = "from POJO as POJO where POJO.tradeDate between :date and :ceilDate"; Query query = getSession().createQuery(hql); // a date having timestamp part, 00:00:00.0, or missing completelyquery.setParameter("date", date); // a date having timestamp part, 23:59:59.999query.setParameter("ceilDate", ceilDate);