Scalar functions

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 1999

SELECT 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 Also

EJB query language
Using EJB query