Re: Q: Monetary Rounding Problem

From: Michael Nolan <nolan_at_helios.unl.edu>
Date: 1995/07/21
Message-ID: <3uojj3$g7j_at_crcnis3.unl.edu>#1/1

choang_at_winternet.com (Carl Hoang) writes:

>Is there a formal method for rounding monetary value? I have this
>problem:

If you use the ROUND function, you specify the decimal precision you want. ROUND(X,2) rounds 2.555 or higher up to 2.56 and anything below is truncated to 2.55.

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_tssi.com, dbms_at_genie.com, nolan_at_inetnebr.com
(posted from nolan_at_helios.unl.edu)

Received on Fri Jul 21 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Manny Pankaj: "ORA-FINAN. POS.-Wash.DC.Metro.Area"
Previous message: Peter Moore: "Re: ORA-600 Internal shared memory fragmentation - HELP!"
In reply to: Carl Hoang: "Q: Monetary Rounding Problem"
In reply to Carl Hoang: "Q: Monetary Rounding Problem"
Next in thread: Gregor Toedte: "Re: Multi-forms app ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message