Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Numeric Functions > CEILING

CEILING

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

Finds the smallest integer greater than or equal to expr. The format appears below:

CEILING(expr)

For example:

CEILING(12.25) = 13
CEILING(12) = 12
Parent topic: Numeric Functions
Previous Topic Next topic Print topic