Wednesday, 3 September 2014

CEIL function in Greenplum

The CEIL functions round the specified number up, and return the smallest number that is greater than or equal to the specified number.

Syntax is:-

CEIL (NUMBER);

Example is:-

SELECT CEILING(12.12);
--> 13

SELECT CEILING(99);
--> 99

SELECT CEILING(-99.99);
--> -99

SELECT CEILING(-32);
--> -32



No comments:

Post a Comment