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 completely
query.setParameter("date", date);
// a date having timestamp part, 23:59:59.999
query.setParameter("ceilDate", ceilDate);
602392714
清零编程群