Details
-
Type:
New Feature
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 0.8.0
-
Component/s: Function/UDF
-
Labels:None
Description
Function Definition
INT8 round(value FLOAT8) INT8 floor(value FLOAT8) INT8 ceil(value FLOAT8)
Example
round
select round(5.1) => 5 select round(5.5) => 6 select round(5.6) => 6 select round(-5.1) => -5 select round(-5.5) => -6 select round(-5.6) => -6
floor
select round(5.1) => 5 select round(5.5) => 5 select round(-5.1) => -6 select round(-5.6) => -6
ceil
select round(5.1) => 6 select round(5.5) => 6 select round(-5.1) => -5 select round(-5.6) => -5