EJB query contains scalar built-in functions for doing type conversions, string manipulation, and for manipulating date-time values. The list of scalar functions is documented in the topic EJB query: Scalar functions.
Example: Scalar functions
Find employees hired in 1999SELECT OBJECT(e) FROM EmpBean e where YEAR(e.hireDate) = 1999
The only scalar functions that are guaranteed to be portable across backend datastore vendors are the following...
The other scalar functions should be used only when DB2 is the backend datastore.
See AlsoEJB query language
Using EJB query