hello hibernate users

a have a very simple schema set up with hibernate working fine so far. i use criteria to search for a particular rows

now i need to use a built in function from mysql. the query is like so:

select dayofmonth(list_date)
from top_ten_title
where list_date between '2004-7-1' and '2004-8-1';

can i use criteria for this also, or what is the suggested way?

You can use Session.createSQLQuery() for that. Or you can use HQL with the day() HQL function (this is recommended, because it's portable). If you want to use Criteria, you have two options: either get the day ouf of the java.util.Date object in the normal way, after the critieria is executed; or map a new dayOfMonth member of your object, specifically for this query.

To do this last one, you'd have to add the new member to your interface/impl in the normal way, and define your mapping as

thank you i will give it a shot. i want to know what the most common practice or best solution is, i dont have to use criteria at all