Round function was discuss on this group. They tell me that it
used round with the C behavior to adjust value near even value. If you
need to adjust with upper value after .5, you need to used programming
language (PHP, VB, C) instead of MySQL round function.
Sommai
At 18:44 28/2/2002 +0100, Roger Baklund wrote:
>* Doug Thompson
> > When you repeated the query, the number of significant places was
> > reduced by one each time.
> > Thus:
> > 100.4235
> > 100.4230
> > 100.4200
> > 100.4000
>
>ah.
>
>No, this was a misunderstanding... this is what I did:
>
>mysql> set @a:=8;
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> select @a:=digits,round(number,@a) from testme;
>+------------+------------------+
>| @a:=digits | round(number,@a) |
>+------------+------------------+
>| 3 | 100.42300000 |
>| 1 | 85.40000000 |
>+------------+------------------+
>2 rows in set (0.00 sec)
>
>mysql> select @a:=digits,round(number,@a) from testme;
>+------------+------------------+
>| @a:=digits | round(number,@a) |
>+------------+------------------+
>| 3 | 100.4 |
>| 1 | 85.4 |
>+------------+------------------+
>2 rows in set (0.00 sec)
>
>(and then I repeated the statement two more times, using @b instead of @a,
>with first zero and then 1 digit decimals as a result.)
>
>Because the number of decimal digits in the result column is decided at
>parse time, and not for each row, the first query return 8 decimals, because
>@a was 8 at parse time, and the second return 1 decimal, because @a was 1 at
>parse time, from the previous select statement:
>
>mysql> select @a:=digits,round(number,@a) from testme order by number;
>+------------+------------------+
>| @a:=digits | round(number,@a) |
>+------------+------------------+
>| 1 | 85.4 |
>| 3 | 100.4 |
>+------------+------------------+
>2 rows in set (0.03 sec)
>
>mysql> select @a:=digits,round(number,@a) from testme order by number;
>+------------+------------------+
>| @a:=digits | round(number,@a) |
>+------------+------------------+
>| 1 | 85.400 |
>| 3 | 100.423 |
>+------------+------------------+
>2 rows in set (0.00 sec)
>
>It was a bit confusing... :o)
>
>--
>Roger
>query
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
----------------------------------------------------------
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
----------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
