Zoomdata Version

Numerical Functions

Function Description Example
CEIL Returns the smallest integer value that is not less than the passed Value CEIL (value : Numeric) : Numeric
FLOOR Returns the largest integer value that is not greater than the passed value FLOOR (value : Numeric) : Numeric
NUM_TO_TEXT Converts the numeric expression to text NUM_TO_TEXT (value : Numeric)
ROUND Rounds a numeric value to the number of decimals specified ROUND (Field_A, 0)
UNIX_TIME_TO_TIME Converts the numeric expression to time UNIX_TIME_TO_TIME (Field_Milliseconds / 1000)

Was this topic helpful?