Numeric functions are used with numeric values. Some numeric functions can also be used with interval and bigdatetime values. Examples of numeric functions include round () and sqrt ().
acos()
Scalar. Returns the arccosine of a given value.
asin()
Scalar. Returns the arcsine of a given value.
atan()
Scalar. Returns the arctangent of a given value.
atan2()
Scalar. Returns the arctangent of the quotient of two given values.
avgof()
Scalar. Returns the average value of multiple expressions, ignoring NULL parameters.
bitand()
Scalar. Returns the result of performing a bitwise AND operation on two expressions.
bitclear()
Scalar. Returns the value of an expression after setting a specific bit to zero.
bitflag()
Scalar. Returns a value with all bits set to zero, except the specified bit.
bitflaglong()
Scalar. Returns a value with all bits set to zero, except a specified bit.
bitmask()
Scalar. Returns a value with all bits set to 0 except a specified range of bits.
bitmasklong()
Scalar. Returns a value with all bits set to 0, except a specified range of bits.
bitnot()
Scalar. Returns the value of an expression with all bits inverted.
bitor()
Scalar. Returns the results of performing a bitwise OR operation on two expressions.
bitset()
Scalar. Returns the value of an expression after setting a specific bit to 1.
bitshiftleft()
Scalar. Returns the value of an expression after shifting the bits left a specific number of positions.
bitshiftright()
Scalar. Returns the value of an expression after shifting the bits right a specific number of positions.
bittest()
Scalar. Returns the value of a specific bit in a binary value.
bittoggle()
Scalar. Returns the value of an expression after inverting the value of a specific bit.
bitxor()
Scalar. Returns the results of performing a bitwise exclusive OR (XOR) operation on two expressions.