MySQL HeatWave User Guide  /  ...  /  Mathematical Functions

### 2.11.9 Mathematical Functions

The following table shows supported mathematical functions. Mathematical functions are not supported with variable-length or dictionary-encoded columns.

Table 2.9 Mathematical Functions

Name Description
`ABS()` Return the absolute value
`ACOS()` Return the arc cosine
`ASIN()` Return the arc sine
`ATAN()` Return the arc tangent
`CEIL()` Return the smallest integer value not less than the argument. The function is not applied to `BIGINT` values. The input value is returned. `CEIL()` is a synonym for `CEILING()`.
`CEILING()` Return the smallest integer value not less than the argument. The function is not applied to `BIGINT` values. The input value is returned. `CEILING()` is a synonym for `CEIL()`.
`COS()` Return the cosine
`COT()` Return the cotangent
`DEGREES()` Convert radians to degrees
`EXP()` Raise to the power of
`FLOOR()` Return the largest integer value not greater than the argument. The function is not applied to `BIGINT` values. The input value is returned.
`LN()` Return the natural logarithm of the argument
`LOG()` Return the natural logarithm of the first argument
`LOG10()` Return the base-10 logarithm of the argument
`MOD()` Return the remainder
`RADIANS()` Return argument converted to radians
`ROUND()` Round the argument
`SIN()` Return the sine of the argument
`SQRT()` Return the square root of the argument
`TAN()` Return the tangent of the argument
`TRUNCATE()` Truncate to specified number of decimal places