This section describes functions returning a numeric value
Contents
| Name | Description |
|---|---|
| Absolute value expression | Returns the absolute value of a numeric expression |
| Ceiling function | Returns the next largest whole number |
| Exponential function | Returns the value of e raised to the power of a numeric expression |
| Extract expression | Returns a date/time field from a datetime or interval |
| Floor function | Returns the next lowest whole number |
| Length expression | Scalar functions to return the length of an item |
| Modulus expression | Returns the modulus (remainder) of a number divided by another |
| Natural logarithm | Returns the natural logarithm of a numeric expression |
| Position expression | Returns the position of a substring within the given character or bit string |
| Power function | Returns a number raised to the specified power |
| Regex occurrences function | Returns the number of times a pattern occurs in another string |
| Regex position function | Returns the position a pattern occurs in another string |
| Square root | Returns the square root of a numeric expression |