Striim 3.9.7 documentation

Numeric functions

function

description

NVL(Object, Object)

return the first object if it is not null, otherwise return the second object, for example:

NVL(COUNT(*),0)
NVL(ROUND_DOUBLE(SUM(Duration/60),1),0)

ROUND_DOUBLE(Object, Object)

round a double to the specified number of places

ROUND_FLOAT(Object, Object)

round a float to the specified number of places

TO_DOUBLE(Object)

convert a byte, float, integer, long, short, or string to a double

TO_FLOAT(Object)

convert a byte, double, integer, long, short, or string to a float

TO_INT(Object):

convert a byte, double, float, long, short, or string to an integer. To convert a JSON object to an integer, use this syntax instead: obj.TO_INT()

TO_LONG(Object)

convert a byte, double, float, integer, short, or string to a long

TO_SHORT(Object)

convert a byte, double, float, integer, long, or string to a short