On 2007-01-31 [EMAIL PROTECTED] wrote:
> Can anyone point me to a section of manual or link how to reduce digits
Lookup the manual for "round()" but be sure that you understand it if you use
round in financial applications as it might be unexpected for you:
mysql> SELECT 25E-1 = 2.5, round(25
Hi,
If you want to round your value to the specified no. of digits, use round().
Else if you want to extract the values without rounding use truncate().
mysql > select round(blustat,2) from parts; [the value will get rounded to
the nearest decimal]
or
mysql > select truncate (blustat,2) fro
Dimitar Vassilev asks:
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysql> desc part;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+---
