# Numeric Functions - [ABS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/abs.md): Calculate absolute value. This function returns the non-negative value of a number, removing any negative sign. - [ACOS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/acos.md): Calculate arc cosine. This function returns the angle in radians whose cosine is the given number. - [ASIN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/asin.md): Calculate arc cosine. This function returns the angle in radians whose cosine is the given number. - [ATAN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/atan.md): Calculate arc tangent. This function returns the angle in radians whose tangent is the given number. - [ATAN2](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/atan2.md): Calculate arc tangent of two variables. This function returns the angle in radians between the positive x-axis and the point (X, Y). - [CEIL](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/ceil.md): Synonym for CEILING(). Rounds a number up to the nearest integer. - [CEILING](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/ceiling.md): Round up to the nearest integer. This function returns the smallest integer value that is greater than or equal to the argument. - [CONV](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/conv.md): Convert numbers between bases. This function transforms a number from one numeric base system to another. - [COS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/cos.md): Calculate cosine. This function returns the cosine of an angle given in radians. - [COT](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/cot.md): Calculate cotangent. This function returns the cotangent of an angle given in radians. - [CRC32](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/crc32.md): Compute cyclic redundancy check. This function returns a 32-bit unsigned integer representing the CRC32 checksum of a string. - [CRC32C](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/crc32c.md): Compute CRC32C checksum. This function calculates a cyclic redundancy check value using the Castagnoli polynomial. - [DEGREES](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/degrees.md): Convert radians to degrees. This function transforms an angle measured in radians to its equivalent in degrees. - [DIV](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/div.md): Perform integer division. This operator divides one number by another and returns the integer result, discarding any remainder. - [EXP](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/exp.md): Calculate exponential value. This function returns the value of e (the base of natural logarithms) raised to the power of the argument. - [FLOOR](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/floor.md): Round down to the nearest integer. This function returns the largest integer value that is less than or equal to the argument. - [LN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/ln.md): Calculate natural logarithm. This function returns the logarithm of a number to the base e. - [LOG](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/log.md): Calculate logarithm. This function returns the natural logarithm of a number, or the logarithm to a specified base if two arguments are provided. - [LOG10](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/log10.md): Calculate base-10 logarithm. This function returns the logarithm of a number to the base 10. - [LOG2](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/log2.md): Calculate base-2 logarithm. This function returns the logarithm of a number to the base 2. - [MOD](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/mod.md): Calculate modulo. This function returns the remainder of a number divided by another number. - [OCT](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/oct.md): Convert to octal. This function returns the octal string representation of a numeric argument. - [PI](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/pi.md): Return the value of pi. This function returns the mathematical constant π (approximately 3.141593). - [POW](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/pow.md): Synonym for POWER(). Returns the value of a number raised to the power of another number. - [POWER](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/power.md): Calculate power. This function returns the value of a number raised to the specified exponent. - [RADIANS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/radians.md): Convert degrees to radians. This function transforms an angle measured in degrees to its equivalent in radians. - [RAND](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/rand.md): Generate a random number. This function returns a random floating-point value between 0 and 1. - [ROUND](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/round.md): Round a number. This function rounds a number to a specified number of decimal places. - [SIGN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/sign.md): Return the sign of a number. This function returns -1, 0, or 1 depending on whether the argument is negative, zero, or positive. - [SIN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/sin.md): Calculate sine. This function returns the sine of an angle given in radians. - [SQRT](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/sqrt.md): Calculate square root. This function returns the non-negative square root of a number. - [TAN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/tan.md): Calculate tangent. This function returns the tangent of an angle given in radians. - [TO\_NUMBER](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/to_number.md): Convert a string to a number. This Oracle-compatible function parses a string using a specified format and returns a numeric value. - [TRUNCATE](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/truncate.md): Truncate a number. This function truncates a number to a specified number of decimal places. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/reference/sql-functions/numeric-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.