[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