Hi,
I have problem when using hibernate criteria for obtaining some data from the database, when the criterion for retrieving this data is of DATE type. The thing is that I want to get only records whose year part of the date is for instance 2007. My hql would have something like this
Code:
select extract(year from c.courseStart),sum(c.courseBasePrice/100) from Course c
Is there any way I could make this work with Criteria since it's much easier to build different joins with it upon which I heavly rely.