[jboss-user] [EJB 3.0] - Re: EJB-QL Convert timestamp to date
fhh
do-not-reply at jboss.com
Tue May 29 16:03:46 EDT 2007
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
More information about the jboss-user
mailing list