1. Home
  2. Computing & Technology
  3. PHP / MySQL

Ceil - MySQL Command

By Angela Bradley, About.com

Definition: Ceiling or Ceil is used to round a number up to the next whole number. Any number with even a slight decimal is rounded up. This is the opposite of Floor which rounds everything down.
Also Known As: Round number up
Examples:
SELECT CEIL(-3.14);
This would round up to -3
SELECT CEIL(3.14);
This would round up to 4
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. SQL Ceil - SQL Ceiling - MySQL Ceil Ceiling

©2009 About.com, a part of The New York Times Company.

All rights reserved.