Archives of the TeradataForum
Message Posted: Thu, 20 May 2004 @ 14:10:43 GMT
You're using Queryman?
Only Bteq cares about formats for output: Queryman is formatting locally on the client whereas Bteq receives formatted strings from Teradata.
you have to cast the numeric value to a string:
select 0.2 (format 'Z.99') (char(4));
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|