Round a column value by parameter.

Round column value by the roundValue parameter.

Usage Details

select *, longRound(column, roundValue) as roundValue from table

-- column: column in the table to apply UDF
-- roundValue: parameter to round column value

-- roundValue: output of UDF, rounded, e.g. 

-- Example
-- table with "port" field and values = 1223
select longRound(col, 100) as roundVal from table

-- will return 1200 for roundVal

© Devo Technology Inc. All Rights Reserved.