Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Best Datatype for Money columns?

Best Datatype for Money columns?

From: shirleyk <shirleykNOshSPAM_at_networkcommerce.com.invalid>
Date: 2000/08/09
Message-ID: <0575b914.ad223d20@usw-ex0101-007.remarq.com>#1/1 






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
Received on Wed Aug 09 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US