A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
EJB and other Java EE Technologies
EJB-QL - Date Range
Joined: Jul 16, 2004
Jul 16, 2004 09:30:00
Can EJB-QL or JBOSS-QL perform date range queries?
SELECT OBJECT(c) FROM customer c WHERE c.DOB BETWEEN ?1 AND ?2
Joined: May 29, 2003
Jul 16, 2004 13:11:00
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.
Nathaniel Stodard<br />SCJP, SCJD, SCWCD, SCBCD, SCDJWS, ICAD, ICSD, ICED
I agree. Here's the link:
subject: EJB-QL - Date Range
EJB QL question
CMP Date sybase
EJB QL BETWEEN Operator
Using EJB-QL LIKE and a replacable param(?1).
SQL and EJB-QL
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013