Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2005 @ 20:04:44 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Workarounds for Decimal18+
 
From:   Dempsey, Mike

I assume you are NOT refering to a Teradata (or PL/1) DECIMAL(18,7) since that is fine on Teradata. [18 digits with 11 before the decimal and 7 after.]

If you mean 18 digits before the decimal AND 7 after (We would refer to it as Decimal(25,7) then you are correct that it can not be represented in a Teradata data type.

Unless you store it as CHAR the best you can do is to use a FLOAT ... but that will only give you 15 digits of precision ... so you dont want to do that if it is money ... or something else that can not be approximated.


Mike Dempsey
Teradata Client Tools



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020