I cannot write HQL functions in a query outside the select clause. I would like to write:

select ...
group by month(someDate)

or

select ...
where year(someDate) > 2011

Submitted by Sander Vermolen on 20 April 2011 at 14:11