Actually that is my mistake for not reading closer. I was focusing on your use of SLQ tables and columns and not Entity classes and properties.
MONTH is not one of the functions that JPA provides. You could do this with a native query however.
[Message sent by forum member 'bbergquist' (bbergquist)]
http://forums.java.net/jive/thread.jspa?messageID=317869