PROTECTED]>
Sent: Thursday, April 08, 2004 10:06 AM
Subject: Re: [PHP-DB] Rounding
> > 6.11 --> 6.2
> > 6.15 --> 6.2
> > 6.19 --> 6.2
> > 6.20 --> 6.2
> >
> > i know there is a ceil() function but that rounds up to the nearest
> > integer..
On Thursday 08 April 2004 09:56, Ng Hwee Hwee wrote:
> is there a way to do rounding up to the nearest tenth? can't use ROUND()
> cos i need something like this:
>
> 6.11 --> 6.2
> 6.15 --> 6.2
> 6.19 --> 6.2
> 6.20 --> 6.2
>
> i know there is a ceil() function but that rounds up to the nearest
>
6.11 --> 6.2
6.15 --> 6.2
6.19 --> 6.2
6.20 --> 6.2
i know there is a ceil() function but that rounds up to the nearest
integer.. i need one decimal place still..
If my math is right, you could multiply the number by ten, take the
CEILING(), then divide that by 10.
Larry
--
PHP Database Mailing