Round Function in MySQL

Question

I have a value of 18.5 and when I used the round(), it remains 18.

How to round off the value to 19.

18.5 ---> 19 [any other functions]

Thankx

http://www.w3resource.com/mysql/mathematical-functions/mysql-round-function.php — Just code, Jun 18 '14 at 09:58
Check this link may be helpful http://stackoverflow.com/questions/4483540/php-show-a-number-to-2-decimal-places — Sadikhasan, Jun 18 '14 at 10:09

score 0 · Accepted Answer · answered Jun 18 '14 at 09:58

0

You might want to refer to the ceil function. Try ceil(18.5)

answered Jun 18 '14 at 09:58

NcDreamy

1 Answers1