Rounding Problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: s.isa (s.isa_at_lycos.com)
Date: 07/04/04

  • Next message: Hugo Kornelis: "Re: Rounding Problem" 
    Date: Sun, 4 Jul 2004 11:50:24 +0300

    Hi all,

    Is there any function that truncates a decimal numeric without rounding, if
    i use cast it rounds the figure but can i don't want that i.e i want it to
    be as follows:

    23.1238 turns to 23.123 and not 23.124 so it keeps only three decimals as
    is

    Please advise if there is any function or so

    Thanks in advance
    Suad

  • Next message: Hugo Kornelis: "Re: Rounding Problem"

    Relevant Pages

    • Re: Rounding Problem
      ... >Is there any function that truncates a decimal numeric without rounding, ... >i use cast it rounds the figure but can i don't want that i.e i want it to ...
      (microsoft.public.sqlserver.mseq)
    • Re: Rounding Dollar Amounts
      ... LineTaxExempt field is checked (meaning tax exempt), ... This works most of the time, but I have run into a few rounding errors. ... With tax exempt checked (and multiple lines) ... By "rounds wrong", I mean I ...
      (comp.databases.ms-access)
    • Re: [OT] Rounding v Truncation, was: Re: Platform Support vs.
      ... > I would regard rounding to be the correct thing to do from a maths viewpoint. ... memories of integer operation rules is that any fractional part is ... Ada rounds and C truncates: ...
      (comp.os.vms)
    • Re: How to round down to nearest 5 minutes, time calc?
      ... Your formula rounds to 15 mins, your subject says to 5 mins. ... The first totals cell shows total exact time, ... The complex rounding down formula I got ...
      (microsoft.public.excel.programming)
    • Re: Rounding up in perl
      ... it just usually isn't the rounding function you ... that's not a question of dependability. ... answer for 50% of all possible values, and it is immediately apparent ... common_round_c rounds 0.1 up. ...
      (comp.lang.perl.misc)