Standard built-in functions

The standard built-in functions supported in Derby are as follows:

• ABS or ABSVAL function
• ACOS function
• ASIN function
• ATAN function
• ATAN2 function
• BIGINT function
• CAST function
• CEIL or CEILING function
• CHAR function
• Concatenation operator
• COS function
• NULLIF function
• CURRENT_DATE function
• CURRENT ISOLATION function
• CURRENT_TIME function
• CURRENT_TIMESTAMP function
• CURRENT_USER function
• DATE function
• DAY function
• DEGREES function
• DOUBLE function
• EXP function
• FLOOR function
• HOUR function
• IDENTITY_VAL_LOCAL function
• INTEGER function
• LENGTH function
• LN or LOG function
• LOG10 function
• LOCATE function
• LCASE or LOWER function
• LTRIM function
• MINUTE function
• MOD function
• MONTH function
• PI function
• RADIANS function
• RTRIM function
• SECOND function
• SESSION_USER function
• SIN function
• SMALLINT function
• SQRT function
• SUBSTR function
• TAN function
• TIME function
• TIMESTAMP function
• TRIM function
• UCASE or UPPER function
• USER function
• VARCHAR function
• YEAR function