Archives of the TeradataForum

Message Posted: Mon, 30 Aug 2004 @ 13:32:30 GMT

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

In Teradata SQL Assistant FLOAT values are displayed with no decimal places BY DEFAULT only. You can right click the column in question and use the 'Decimal Places' sub menu to reset to 1 (or more) decimal place.

Alternatively, if the Float columns you normally return have decimal places you can change the default on the AnswerSet tab of the options screen. This new default will be applied to all future query results. (The default of zero was chosen because many Float columns actually contain large integers - such as in the Teradata dictionary. In most cases, Decimal would be used for such things as money, where you need to use 'exact' arithmetic.)

Mike Dempsey
Teradata Client Tools

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