Archives of the TeradataForum

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

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

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