How to use the CURRENT_DATE function in a hibernate criterion?

Question

I want to translate the following HQL into Criteria notation:

from Deal
where CURRENT_DATE between startDate and endDate

I tried using Restrictions.between but it doesn't recognize current_date

Criteria c = session().createCriteria(Deal.class)
   .add(Restrictions.between("CURRENT_DATE", "startDate", "endDate");

Answer 1

1. Actually this function is called current_date. So you need to use it in lowercase.
2. Your between criteria is used incorrect, first parameter is name of the property, second and third are values.

To solve the issue you need to rewrite it in the following way:

 Criteria c = session().createCriteria(Deal.class)
    .add(Restrictions.gt("startDate", "current_date")
    .add(Restrictions.lt("endDate", "current_date");