Numeric Functions
Function | Description | Examples |
|---|---|---|
CEIL | Returns the smallest integer value that is greater than or equal to the value (n). | 13551.8 becomes 13552 |
FLOOR | Returns the largest integer value that is less than or equal to the value (n). | 13551.8 becomes 13551 |
ROUND | Rounds a number to the specified number of decimal places: Negative arguments indicate rounding to the left of the decimal point. Positive arguments round to the right of the decimal point. | 25.193 with an argument of 1 will round to 25.2 |
SIGN | Returns a number that represents the sign of a value (n). | -1 if n < 0; 0 if n = 0; 1 if n >0 |
TRUNC | Truncates a value to the specified number of decimal places. | 25.193 with an argument of 1 will truncate to 25.1 |