ceil

Updated on 2023-10-25 GMT+08:00

This function is used to round up a to the nearest integer.

Syntax

ceil(DOUBLE a)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

The value can be a float, integer, or string.

If the value is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation.

Return Values

The return value is of the DECIMAL type.

NOTE:

If the value of a is NULL, NULL is returned.

Example Code

The value 2 is returned.

select ceil(1.3);

The value -1 is returned.

select ceil(-1.3);

The value NULL is returned.

select ceil(null);
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback