This one time, at band camp, chad nash said:
cn>I am trying to get a handle on date manipulation in OQL.
cn>Any references? (I could not find any)
cn>
cn>Obviously you can do any manipulation you want, in java, to the
cn>parameters you bind to the OQL.
cn>
cn>Do + and - work for dates? (I imagine not)
cn>
cn>Can you access the components of a date (year month day)?
cn>
cn>
cn>An example is
cn>SELECT o FROM Order o where o.orderFilledDate - o.orderReceviedDate > 30
cn>
cn>(30 days that is)
Chad,
There is currently no date manipulation or arithmetic functionality in the
Castor OQL engine. I have actually been planing on checking in a new
impl of the OQL engine that is written using ANTLR. This new impl using
ANTLR will make adding functionality far easier than it is today. Unfortunately
the priority of this particular task been usurped numerous times by other more
important tasks. But I'll get it in there sooner or later and at that time then
adding these types of features will be easier.
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
The Castor Project
http://www.castor.org/
Apache Geronimo
http://incubator.apache.org/projects/geronimo.html
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
