CEIL / CEILING - Amazon Kinesis Data Analytics SQL Reference
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

CEIL / CEILING

CEIL | CEILING ( <number-expression> ) CEIL | CEILING ( <datetime-expression> TO <time-unit> ) CEIL | CEILING ( <number-expression> ) CEIL | CEILING ( <datetime-expression> TO <[[time-unit> )

When called with a numeric argument, CEILING returns the smallest integer equal to or larger than the input argument.

When called with a date, time, or timestamp expression, CEILING returns the smallest value equal to or larger than the input, subject to the precision specified by the <time unit>.

Returns null if any input argument is null.

Examples

Function Result

CEIL(2.0)

2

CEIL(-1.0)

-1

CEIL(5.2)

6

CEILING(-3.3)

-3

CEILING(-3 * 3.1)

-9

CEILING(TIMESTAMP '2004-09-30 13:48:23' TO HOUR)

TIMESTAMP '2004-09-30 14:00:00'

CEILING(TIMESTAMP '2004-09-30 13:48:23' TO MINUTE)

TIMESTAMP '2004-09-30 13:49:00'

CEILING(TIMESTAMP '2004-09-30 13:48:23' TO DAY)

TIMESTAMP '2004-10-01 00:00:00.0'

CEILING(TIMESTAMP '2004-09-30 13:48:23' TO YEAR)

TIMESTAMP '2005-01-01 00:00:00.0'

Notes

  • CEIL and CEILING are synonyms for this function provided by the SQL:2008 standard.

  • CEIL(<datetime value expression> TO <time unit>) is an Amazon Kinesis Data Analytics extension.

  • For more information, see FLOOR.