Archives of the TeradataForum
Message Posted: Thu, 03 Feb 2005 @ 20:04:44 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|