SQL/MySQL/Math/Floor Ceiling

Use CEILING in MySQL

   <source lang="sql">

/* mysql> select CEILING(-1.4); +---------------+ | CEILING(-1.4) | +---------------+ | -1 | +---------------+ 1 row in set (0.01 sec) mysql> select CEIL(0.5); +-----------+ | CEIL(0.5) | +-----------+ | 1 | +-----------+ 1 row in set (0.01 sec)

• /

select CEILING(-1.4); select CEIL(0.5);

      </source>
   
  

Use FLOOR in MySQL

   <source lang="sql">

/* mysql> select FLOOR(12.345); +---------------+ | FLOOR(12.345) | +---------------+ | 12 | +---------------+ 1 row in set (0.00 sec) mysql> select FLOOR(-12.3456); +-----------------+ | FLOOR(-12.3456) | +-----------------+ | -13 | +-----------------+ 1 row in set (0.00 sec)

• /

select FLOOR(12.345); select FLOOR(-12.3456);

      </source>