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.

Regards,

Victor