Archives of the TeradataForum

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

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

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>>