Compara Fechas en Hibernate

Ejemplo de codigo para comparar fechas en hibernate utilizando "between" en una sentencia hsql



Ejemplo 1 between

String queryHQL = "SELECT i FROM Invoice i WHERE i.invoiceDate between :fromdate and :todate";

query = entityManager.createQuery(queryHQL);

query.setParameter("fromdate", jXDatePicker1.getDate());

query.setParameter("todate", jXDatePicker2.getDate());


Ejemplo 2



Calendar cal = Calendar.getInstance();
Date today = cal.getTime();
cal.add(Calendar.DAY_OF_YEAR, -1);
Date yesterday = cal.getTime();


query = entityManager.createQuery("SELECT C FROM CaseHeader C WHERE  C.createdAt between :_yesterday and :_today");
query.setParameter("_yesterday", yesterday);
query.setParameter("_today", today);