These scalar functions perform a calculation, usually based on input values provided as arguments, and return a numeric value.
| ABS | LOG10 |
| ACOS | PI |
| ASIN | POWER |
| ATAN | RADIANS |
| ATN2 | RAND |
| CEILING | ROUND |
| COS | SIGN |
| COT | SIN |
| DEGREES | SQUARE |
| EXP | SQRT |
| FLOOR | TAN |
| LOG |
Note Arithmetic functions, such as ABS, CEILING, DEGREES, FLOOR, POWER, RADIANS, and SIGN, return a value having the same data type as the input value. Trigonometric and other functions, including EXP, LOG, LOG10, SQUARE, and SQRT, cast their input values to float and return a float value.