[jboss-user] [EJB 3.0] - Re: EJB-QL Convert timestamp to date

But this only works if a.) the truncated value is a parameter in the query b.) you are actually truncing to the day. It will not work for something like this: | SELECT c, d FROM Cat c, Dog d | WHERE extract(month from c.birthday) = extract(month from d.birthday)# AND extract(year from c.birthday) = extract(year from d.birthday) | which will return all cat/dog tuples which were born in the same month. Regards Felix P.S.: All untested, of course. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4050032#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...