CEILING
Description
Sample Source Pattern
Syntax
CEILING( expression )CEIL( <input_expr> [, <scale_expr> ] )Math.ceil( expression )Examples
SELECT CEILING(642.20);CEILING(642.20)|
---------------+
643 |SELECT CEIL(642.20);CEIL(642.20)|
------------+
643 |CREATE OR REPLACE FUNCTION compute_ceil(a double)
RETURNS double
LANGUAGE JAVASCRIPT
AS
$$
return Math.ceil(A);
$$
;
SELECT COMPUTE_CEIL(642.20);COMPUTE_CEIL(642.20)|
--------------------+
643|Last updated
Was this helpful?