MySQL Numeric Functions

20 functions

ABSABS(x)

Returns the absolute value.

CEILCEIL(x)

Returns the smallest integer not less than x (ceiling).

FLOORFLOOR(x)

Returns the largest integer not greater than x (floor).

ROUNDROUND(x, d)

Rounds x to d decimal places.

TRUNCATETRUNCATE(x, d)

Truncates x to d decimal places.

MODMOD(n, m)

Returns the remainder of n divided by m.

POWERPOWER(x, y)

Returns x raised to the power of y.

SQRTSQRT(x)

Returns the square root.

EXPEXP(x)

Returns e raised to the power of x.

LOGLOG(x) / LOG(b, x)

Returns the natural logarithm, or logarithm base b.

LOG2LOG2(x)

Returns the base-2 logarithm.

LOG10LOG10(x)

Returns the base-10 logarithm.

RANDRAND([seed])

Returns a random floating-point value between 0 and 1.

SIGNSIGN(x)

Returns 1 for positive, 0 for zero, -1 for negative.

PIPI()

Returns the value of pi.

DEGREESDEGREES(x)

Converts radians to degrees.

RADIANSRADIANS(x)

Converts degrees to radians.

SINSIN(x)

Returns the sine value.

COSCOS(x)

Returns the cosine value.

TANTAN(x)

Returns the tangent value.