List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 28 1999 8:17pm
Subject:Re: Weird ROUND behaviour
View as plain text  
On Tue, 1999-09-28 11:14:26 -0600, Steve Ruby wrote:
> > The expected behaviour for ROUND(), as I see it, would be to round
> > toward the nearest integer number:
> >   ROUND(-1.9) --> -2
> >   ROUND(-1.1) --> -1
> >   ROUND(0.1)  -->  1     <--------  I assume you mean 0 here ?
> >   ROUND(0.9)  -->  2
                      ^^^
                      And this should be '1'!

Thanks for the correction!  Again one of these nasty errors if you
write in a hurry ;)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
Weird ROUND behaviourJuho Tikkala27 Sep
  • Re: Weird ROUND behaviourPaul DuBois27 Sep
    • Re: Weird ROUND behaviourMartin Ramsch28 Sep
      • Re: Weird ROUND behaviourThimble Smith28 Sep
  • Re: Weird ROUND behaviourSteve Ruby28 Sep
    • Re: Weird ROUND behaviourMartin Ramsch28 Sep
    • Re: Weird ROUND behaviourMichael Widenius29 Sep
      • Re: Weird ROUND behaviourBob Kline29 Sep
        • Re: Weird ROUND behaviourTonu Samuel29 Sep
          • Re: Weird ROUND behaviourJames Manning29 Sep
        • Re: Weird ROUND behaviourScott Hess29 Sep
        • Re: Weird ROUND behaviourTonu Samuel30 Sep
        • Re: Weird ROUND behaviourScott Hess30 Sep
        • Re: Weird ROUND behaviourTonu Samuel30 Sep