This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EJB-QL - Date Range

 
BoonHock Ng
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can EJB-QL or JBOSS-QL perform date range queries?

EG.
SELECT OBJECT(c) FROM customer c WHERE c.DOB BETWEEN ?1 AND ?2
 
Nathaniel Stoddard
Ranch Hand
Posts: 1258
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It doesn't look like it (at least not up to 2.0). You can download the 2.1 specs and check out the EJB-QL EBNF to see for yourself. 2.0 wants scalar values, or functions that produce scalar values to do what you want -- not dates.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic