Numeric Macro Functions (FireDAC)

Go Up to Preprocessing Command Text (FireDAC)

The following table lists the numeric macro functions:

Function Description Local expression engine
ABS(numeric_exp) Returns the absolute value of numeric_exp. +
ACOS(float_exp) Returns the arccosine of float_exp as an angle, expressed in radians. +
ASIN(float_exp) Returns the arcsine of float_exp as an angle, expressed in radians. +
ATAN(float_exp) Returns the arctangent of float_exp as an angle, expressed in radians. +
ATAN2(float_exp1, float_exp2) Returns the arctangent of the x and y coordinates, specified by float_exp1 and float_exp2, respectively, as an angle, expressed in radians. +
CEILING(numeric_exp) Returns the smallest integer greater than or equal to numeric_exp. The return value is of the same data type as the input parameter. +
COS(float_exp) Returns the cosine of float_exp, where float_exp is an angle expressed in radians. +
COT(float_exp) Returns the cotangent of float_exp, where float_exp is an angle expressed in radians. +
DEGREES(numeric_exp) Returns the number of degrees converted from numeric_exp radians. +
EXP(float_exp) Returns the exponential value of float_exp. +
FLOOR(numeric_exp) Returns the largest integer less than or equal to numeric_exp. The return value is of the same data type as the input parameter. +
LOG(float_exp) Returns the natural logarithm of float_exp. +
LOG10(float_exp) Returns the base 10 logarithm of float_exp. +
MOD(integer_exp1, integer_exp2) Returns the remainder (modulus) of integer_exp1 divided by integer_exp2. +
PI( ) Returns the constant value of pi as a floating-point value. +
POWER(numeric_exp, integer_exp) Returns the value of numeric_exp to the power of integer_exp. +