| Function | Description | Standard |
|---|
| abs(x) | Takes the absolute value of x. abs(x) is always positive, zero, or NULL (if x is NULL). Not defined for strings or datetime values. | ANSI |
| acos(x) | Computes the arccosine of x in radians. | Sybase/MSSQL and MySQL. |
| asin(x) | Computes the arcsine of x in radians. | Sybase/MSSQL and MySQL. |
| atan(x) | Computes the arctangent of x in radians. | Sybase/MSSQL and MySQL. |
| atan2(x,y) | Computes the arctangent of y/x in radians, and permits x == 0. | MySQL. |
| constrain(v,a,b) | Constrains the value v to be between (inclusive) the minimum value a and the maximum value b. Operates on integers, doubles, and money types. Leave a or b NULL if they don't apply. | Centrallix. |
| cos(a) | Computes the cosine of the angle a, given in radians. | Sybase/MSSQL and MySQL. |
| degrees(a) | Converts the angle a, given in radians, to degrees. | Sybase/MSSQL and MySQL. |
| log10(x) | Computes the base-10 logarithm of x. | Sybase/MSSQL and MySQL. |
| power(x,y) | Raises the value x (double, integer, or money) to the y (double or integer) power. | ANSI. |
| radians(a) | Converts the angle a, given in degrees, to radians. | Sybase/MSSQL and MySQL. |
| rand(s) | Computes a random value, given the optional random seed s. If the seed is provided, the random number generator is initialized with that seed. Providing an initial seed (prior to further calls to rand() in the same query context) can provide a reproducible random number stream, which is useful in some cases. Return value is a double y such that 0.0 <= y < 1.0. The underlying algorithm may change in the future, so random sequences with a given seed should not be relied upon as static over the long term. | Sybase/MSSQL and MySQL. |
| round(n,d) | Rounds the value n to d decimal places (to the right of the decimal point). If d is zero, rounds n to a whole number. If d is negative, rounds to (-d) digits to the left of the decimal point (example: d = -1 means round to the nearest 10). | Sybase/MSSQL and MySQL |
| sin(a) | Computes the sine of the angle a, given in radians. | Sybase/MSSQL and MySQL. |
| sqrt(x) | Computes the square root of x. | ANSI. |
| square(x) | Computes the square of x. | Sybase/MSSQL and MySQL. |
| tan(a) | Computes the tangent of the angle a, given in radians. | Sybase/MSSQL and MySQL. |
| truncate(n,d) | Truncates the value n to d decimal places (to the right of the decimal point). If d is zero, truncates n to the nearest whole number equal or smaller in magnitude (closer to zero). If d is negative, truncates to (-d) digits to the left of the decimal point (example: d = -1 means truncate to the nearest 10). | Sybase/MSSQL and MySQL |
