CEILING

 

The function CEILING returns the smallest integer for the numeric expression.

SQL Syntax:
   CEILING( number )
Number:
  Any numeric expression.
Escape Syntax:
  {fn CEILING( number )}
Return Type:
  FLOAT
     

Examples:

  • SELECT CEILING(1.3), {fn ceiling(-0.5)}

see also:
SQL Numeric Functions
ROUND
TRUNCATE


100% pure Java DBMS
Mirror Site