jboss QL with date and clause where

tbaud72 Jan 20, 2005 10:42 AM

Hello,

I would like to write a finder in an EJB CMP with a date attribute(datenews).
I would like to get the most recent objet from an EJB (max 2 month), is it possible with EJB-QL.

It could seem to this expression (don't work) :

query="SELECT OBJECT(n) FROM News AS n where TO_DAYS(NOW()) - TO_DAYS(datenews) <= 60

thanks

1. Re: jboss QL with date and clause where

fbiaggi Jan 20, 2005 12:12 PM (in response to tbaud72)

Hello,

you may try jboss-ql or declared-sql
Actions
2. Re: jboss QL with date and clause where

tbaud72 Jan 24, 2005 11:05 AM (in response to tbaud72)

ok

but what is the syntax expression with jboss-ql ?

Can i manage to compare date data with jboss-ql ?

Thanks
Actions

Go to original post