Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 24 May 2002 @ 14:52:31 GMT

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

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

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 character string.

  <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