 |
 |
Archives of the TeradataForum
Message Posted: Fri, 28 May 2004 @ 07:38:44 GMT
| Subj: | | Re: Equivalent Data Type |
| |
| From: | | Dieter Noeth |
Hari-Pattisapu wrote:
| | You could use the same type in teradata too as DECIMAL(n,p), Number(n,p) | |
No, the maximum number of digits in Teradata is 18 and the OP asked for DECIMAL(38,18).
A possible solution in V2R5.1 would be some UDFs on a Byte(16) column returning strings.
On the other hand, in most cases 18 digits is enough and dec(38) have only been chosen because it's the maximum number...
Dieter
| |
