Archives of the TeradataForum
Message Posted: Fri, 24 May 2002 @ 14:52:31 GMT
| Subj: || || Re: Format statement and floating point numbers |
| From: || || John Hall |
You're limited to 18 digits.
Looking at your example, it looks like you're trying to hold an employee number as a FLOAT. If so, you need to be careful because there
are rounding errors that are inherent floating point data type and so there will be employee numbers that you won't be able accurately
In my experience, a value like an employee number can be decomposed into fields or if it has to be that large, it needs to be held as a