Archives of the TeradataForum
Message Posted: Wed, 29 Oct 2003 @ 15:33:22 GMT
| 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.
| 
