Re: rounding digits after decimal sign

2007-02-02 Thread Christian Hammers
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

Re: rounding digits after decimal sign

2007-02-01 Thread ViSolve DB Team
ruary 01, 2007 1:40 AM Subject: rounding digits after decimal sign 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 | Nul

Re: rounding digits after decimal sign

2007-01-31 Thread dpgirago
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 | +-+---

rounding digits after decimal sign

2007-01-31 Thread Dimitar Vasilev
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 | +-+--+--+-+