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 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3862933#3862933 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3862933 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
