CEILING
Description
A mathematical function that returns the smallest greater integer greater/equal to the number sent as a parameter (CEILING in Transact-SQL).
Sample Source Pattern
Syntax
CEILING( expression )CEIL( <input_expr> [, <scale_expr> ] )Math.ceil( expression )Examples
Code:
SELECT CEILING(642.20);Result:
CEILING(642.20)|
---------------+
643 |Code:
SELECT CEIL(642.20);Result:
CEIL(642.20)|
------------+
643 |Code:
CREATE OR REPLACE FUNCTION compute_ceil(a double)
RETURNS double
LANGUAGE JAVASCRIPT
AS
$$
return Math.ceil(A);
$$
;
SELECT COMPUTE_CEIL(642.20);Result:
COMPUTE_CEIL(642.20)|
--------------------+
643|Last updated
Was this helpful?