Archives

The List

« MySQL Pop Quiz #24 | Main | How to Kill Your Book Sales »

CEILING() :: MySQL Function of the Day

By Carsten | April 15, 2008

Function name: CEILING()
Aliases: CEIL()
Function type: Numeric function
Purpose: Return the nearest integer which is equal or higher

Description: CEILING returns the integer value which is higher than or equal to the argument: CEILING(30.1), CEILING(30.9) and CEILING(31) all return 31.

For negative numbers, notice that this function will round toward zero: CEILING(-30.1), CEILING(-30.9) and CEILING(-30) all return -30.

MySQL manual entry on CELING()

MySQL Function of the Day is a small series of concise information regarding most of the functions and operators available in MySQL. Inspired by PHPs funcaday, it’s meant to provide a daily dose of something in-between “Aha!” and “Ho-hum, I knew that already”, depending on your level of experience with MySQL. You can access the entire series with your browser here or pick up the RSS feed here.

Topics: MySQL Function of the day |

One Response to “CEILING() :: MySQL Function of the Day”

  1. MySQL Function of the Day: Week Six | Carsten’s Random Ramblings Says:
    April 23rd, 2008 at 12:45 am

    [...] Tuesday, April 15th 2008: CEILING() [...]

Comments