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-mail)
> > Subject: Round Question
> >
> >
> > 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
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
