Function Expressions
A function expression can return one or more values from built-in SQL functions or from
user-defined functions, as the following diagram shows.
The following examples show function expressions:
EXTEND (call_dtime, YEAR TO SECOND)
HEX (LENGTH(123))
MDY (12, 7, 1900 + cur_yr)
TAN (radians)
DATE (365/2)
ABS (-32)
LENGTH ('abc') + LENGTH (pvar)
EXP (3)
HEX (customer_num)
MOD (10,3)