Rounding and Truncation Functions
CEIL( <expr> )
Returns the smallest integer which is greater than or equal to the specified numerical expression.
FLOOR( <expr> )
Returns the largest integer which is less than or equal to the specified numerical expression.
ROUND( <expr> [, <scale> ] )
Returns the numeric value, rounded off to a given number of decimal places, of the input numeric expression. If the scale factor is not specified, it will round off to the nearest integer.
scale
- optional numeric expression, representing the number of decimal places to be rounded off to in a given numeric expression. Default is 0.
ABS( <expr> )
Returns the absolute value of the specified numeric expression.
SIGN( <expr> )
The SIGN function returns the sign of its argument:
Returns -1 if the argument is negative
Returns 1 if the argument is positive
Returns 0 if the argument is 0
MOD( <expr> )
Returns the remainder of a number divided by another number
Support datatype: INT/DOUBLE
Last updated