Re: Best Datatype for Money columns?

From: Stefan Roesch <Stefan.Roesch_at_t-online.de>
Date: 2000/08/09
Message-ID: <3991A5A8.2D2C7CA4@t-online.de>#1/1

shirleyk wrote:

> Are there best practices for storing money in an Oracle
> Database? I've been using number(38,2), but now I'm interfacing
> with a system where money columns have been defined as float.
> I've done some tests, and haven't seen any rounding errors yet,
> but does anybody have any advice?
>
> Thanks,
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com

Floats are internally converted to the number datatype Stefan Received on Wed Aug 09 2000 - 00:00:00 CDT