Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Oct 2003 @ 15:33:22 GMT


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


Subj:   Re: AVERAGE Results?
 
From:   Dempsey, Mike

I missed the start of this thread so I'm kind of guessing here...

SQL Assistant (Queryman) allows you to specify how many decimal places you want to see. (Although you can request up to 14, it really depends on how many the DBS actually returned. That would be 5 for a 'single', 15 for a 'double' [a Teradata FLOAT], or 'n' for Decimal(m,n).) To request more than 4 you must use the 'Format Cells' command.

Teradata Administrator (WinDDI) allows you to select the number of decimal places (up to 4 only.) for FLOAT columns in an Answer window. (Highlight the column and Right click to see the menu.)

An ODBC application can determine how many decimal places it wants to display - it really depends on whoever writes the application and what type of data is normally returned. If you primarily deal with 'counters' then default to zero. If you primarily deal with money you should default to 2, etc.

Mike Dempsey
Teradata Client Tools.



     
  <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: 15 Jun 2023