Re: displaying smallmoney to 2 decimal places

On Fri, 28 Oct 2005 18:05:01 -0700, Kim wrote:

>Heres an example of a query with the display
>
>SELECT * FROM STOCKks WHERE Price < Cost; Both price and cost are
>smallmoney datatypes. They display with 4 digits to the left of decimal pt.
>How do I set it to display only 2 digits for both colums?
>
>THanks, Kim

Hi Kim,

The best advise is to:
a) do formatting in the front end, not at the server, and
b) avoid the use of money and smallmoney datatype, becuase they are
proprietary and non-portable AND because they suffer from some strange
rounding issues. Use DECIMAL (17,2) instead.

If you must use money and must do the formatting at the server, then
SELECT CAST (Price AS DECIMAL(17,2))
will work.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Re: Labor Day in Tx...
    ... anytime, or just send the money to kw@xxxxxxxxxxx ... Maybe...It's just that my screen won't display more than 8 digits to the ...
    (rec.motorcycles.dirt)
  • Re: Cobol Myth Busters
    ... than just TRUNC (wich has 3 flavors on IBM zSeries). ... using 18 digits: packed decimal is 74% faster than binary ... packed decimal is 60% slower than binary ... DISPLAY compared to packed decimal ...
    (comp.lang.cobol)
  • Re: FPGA Journal Article
    ... 10 decimal digits fixed-point display, ... Above 1 MHz limited by time base accuracy, below 1 MHz by display ... but clutter up the design. ... A 20 times more accurate time base would cost <$20 extra. ...
    (comp.arch.fpga)
  • Re: Reducing load for LAMP app?
    ... Using microtime() as-is: 2.6941299438477E-5 ... 2.6941299438477E-5 is standard scientific notation for display of very large or very small numbers. ... Another point here is that floating point numbers have up to 15 significant digits ... I'd suggest you follow up in the Linux admin groups - where the experts hang out. ...
    (comp.lang.php)
  • Re: Please help - want to buy a Mac!
    ... I'll bet you'll have money left ... Macbook... ... However, you *can* get an external display, either ... If you get the AppleCare warranty, it will also extend the warranty on ...
    (comp.sys.mac.misc)