If the ceil function won't do it you can truncate it and add 1.
Ty...
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 2:12 PM
To: Fabio Bernardo; Mysql (E-mail)
Subject: RE: Round Question
what I've done is
select ceil(value)
Hi,
I tried:
Select ceiling(1.2)
It worked and returned "2".
HTH
Allen
> -Original Message-
> From: Dan Greene [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 12:12 PM
> To: Fabio Bernardo; Mysql (E-mail)
> Subject: RE: Round Question
>
what I've done is
select ceil(value)
(not sure if ceil is the function on MySQL, but there is a ceiling function, I'm
sure...)
> -Original Message-
> From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 2:59 PM
> To: Mysql (E-
I write this command:
Select round(1.1)
and obtain 1 as answer
Is there a round command to obtain 2 as answer. I mean, in Excel this
command is knwon as RoundUp!
thanks a lot
