Have you tried 'cast(foo.timestamp AS date)' and 'extract(year from foo.timestamp)'? For the later one there are also abbraviations like day(xxx) etc. but these are Hibernate specific.
I have never tried these myself but they are definitly in the manual. Regards Felix View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4049518#4049518 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4049518 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
