SQL Numeric Functions

ABS()

Returns the absolute value of numeric expression.

ACOS()

Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1.

ASIN()

Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1

ATAN()

Returns the arctangent of numeric expression.

ATAN2()

Returns the arctangent of the two variables passed to it.

BIT_AND()

Returns the bitwise AND all the bits in expression.

BIT_COUNT()

Returns the string representation of the binary value passed to it.

BIT_OR()

Returns the bitwise OR of all the bits in the passed expression.

CEIL()

Returns the smallest integer value that is not less than passed numeric expression.

CEILING()

Returns the smallest integer value that is not less than passed numeric expression.

CONV()

Convert numeric expression from one base to another.

COS()

Returns the cosine of passed numeric expression. The numeric expression should be expressed in radians.

COT()

Returns the cotangent of passed numeric expression.

DEGREES()

Returns numeric expression converted from radians to degrees.

EXP()

Returns the base of the natural logarithm (e) raised to the power of passed numeric expression.

FLOOR()

Returns the largest integer value that is not greater than passed numeric expression.

FORMAT()

Returns a numeric expression rounded to a number of decimal places.

GREATEST()

Returns the largest value of the input expressions.

INTERVAL()

Takes multiple expressions exp1, exp2 and exp3 so on.. and returns 0 if exp1 is less than exp2, returns 1 if exp1 is less than exp3 and so on.

LEAST()

Returns the minimum-valued input when given two or more.

LOG()

Returns the natural logarithm of the passed numeric expression.

LOG10()

Returns the base-10 logarithm of the passed numeric expression.

MOD()

Returns the remainder of one expression by diving by another expression.

OCT()

Returns the string representation of the octal value of the passed numeric expression. Returns NULL if passed value is NULL.

PI()

Returns the value of pi

POW()

Returns the value of one expression raised to the power of another expression

POWER()

Returns the value of one expression raised to the power of another expression

RADIANS()

Returns the value of passed expression converted from degrees to radians.

ROUND()

Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points

SIN()

Returns the sine of numeric expression given in radians.

SQRT()

Returns the non-negative square root of numeric expression.

STD()

Returns the standard deviation of the numeric expression.

STDDEV()

Returns the standard deviation of the numeric expression.

TAN()

Returns the tangent of numeric expression expressed in radians.

TRUNCATE()

Returns numeric exp1 truncated to exp2 decimal places. If exp2 is 0, then the result will have no decimal point.

Top