1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Ceil - MySQL Command

By

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
Top Related Searches
  • ceil
  • whole number
    1. About.com
    2. Technology
    3. PHP / MySQL
    4. MySQL Commands
    5. SQL Ceil - SQL Ceiling - MySQL Ceil Ceiling

    ©2014 About.com. All rights reserved.