ceiling

Returns the smallest integer greater than or equal to the specified value.

Syntax

ceiling(value)

Parameters

Examples

Usage

ceiling, a mathematical function, returns the smallest integer that is greater than or equal to the specified value. The return value has the same datatype as the value supplied.

For numeric and decimal values, results have the same precision as the value supplied and a scale of zero.

See also:
  • set in Reference Manual: Commands.

  • Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute ceiling.

Related reference
abs
floor
round
sign