My table has date fields with type as datetime or timestamp. I would like to fetch the records based on the values of these fields.
That is, let's say, I want all records inserted or updated today. What would be the HQL for the same?

I don't want to use Criteria API but only HQL.

Thanks.

.

Following HQL serves the purpose:

From someTable where (day(createdOn) = day(current_date())) and (month(createdOn) = month(current_date())) and (year(createdOn) = year(current_date()))

Assumption: "createdOn" is a date/time field.

Any better solution??