Standard built-in functions

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

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