CEIL与FLOOR

SQL> SELECT 666.88,CEIL(666.88),FLOOR(666.88) FROM dual;
    666.88 CEIL(666.88) FLOOR(666.88)
---------- ------------ -------------
    666.88          667           666

CEIL returns the smallest integer that is greater than or equal to n.

FLOOR returns the largest integer equal to or less than n. 

CEIL与FLOOR

原文：http://www.cnblogs.com/wwxbi/p/4176696.html