Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

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

Please provide your feedback in the comments section above. Please don't forget to follow.