Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

CEILING function (ODBC compatible)

Syntax

CEILING ( expression )

Description

The scalar function CEILING returns the smallest integer greater than or equal to expression.

Example

SELECT CEILING (32.5) 'Ceiling'

FROM ADMIN.SYSCALCTABLE;

Notes

  • Expression must evaluate to a numeric data type.

TOCIndex