Use CEILING in MySQL : Floor Ceiling : Math SQL / MySQL

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » Math » Floor Ceiling »

Use CEILING in MySQL



/*
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);