Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 29 Aug 2005 @ 12:16:11 GMT

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

Subj:   Re: Problem with with Decimal field in Fast Export
From:   Victor Sokovin

  I have tried casting to a character field but it changes the result to:  

          >  1.85460621446000E 007
          >  1.25000000000000E 002
          >  3.27500000000000E 002
          >  3.23950000000000E 003

Try to CAST the SUM first to DECIMAL(m,n) (m and n large enough to accommodate the sum and avoid numeric overflows!) and only then to CHAR. What you see now is the default FLOAT format for the SUM. I think FLOAT had been chosen as default to address potential overflow issues with sums.



  <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