Numeric Expression Functions

Mathematical Expression Functions

Expression Function List

String Expression Functions

The following numeric expression functions are supported.

Function Name	Description
Ceil	Returns the smallest integer greater than or equal to a numeric expression.
Floor	Returns the largest integer less than or equal to a numeric expression.
Round	Returns the rounded value of a numeric expression.
Sign	Returns -1 if the provided numeric expression evaluates to a value less than 0, 0 if the expression evaluates to 0 and 1 if the expression evaluates to a value bigger than 0.
Trunc	Truncates a numeric or date expression.
Table 6: List of numeric expression functions