Functions Overview

Mathematic Functions

Performs a calculation based on input values provided as parameters to the function, and returns a numeric value.

Function	Description
ABS	Returns an absolute (positive) value of the specified numeric value.
MOD	Divides one number by another number and returns the remainder.

The following functions perform an operation on a string input value and return a string value.

Function	Description
SUBSTRING	Is used to get a part of a string.
CHARACTER_LENGTH	Returns the number of characters of the given string.
POSITION	Searches this string for the first match of a substring and returns its starting position if found.
UPPER	Returns the symbol expression, in which symbols of lower case symbols are converted into upper case symbols.
LOWER	Returns a symbol expression after converting lower case symbols into upper case symbols.
RANDOM_STRING	Returns a random string of a specified length.
DN	Returns the distinguished name of the entry.
PARENT_DN	Returns the distinguished name of the parent entry.

These functions are used to get a date-time value.

Function	Description
CURRENT_DATE	Returns the value of type GeneralizedTime that contains the current date.
CURRENT_TIME	Returns the value of type GeneralizedTime that contains the current time.
CURRENT_TIMESTAMP	Returns the value of type timestamp that contains the current date and time.

Function	Description
CAST	Explicitly converts an expression of one data type to another.