Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 25 Feb 2011 @ 13:55:46 GMT


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


Subj:   Decimal display problem
 
From:   Attila_Finta

I use TD SQL Assistant v13 and Nexus v5 to query TD. I have the same challenge in both, so I think it may be my SQL syntax

I am trying to create percentages. I have simplified my SQL to the following, for discussion purposes:

     select
     cast( (3995852 * 100 / 12274677) as Decimal(6,3) ) as Data_Pct

The result I receive is 32. But the result that I expect is 32.554.

I have tried adding a FORMAT clause but that seems to not make a difference either. Suggestions?


Attila Finta



     
  <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: 27 Dec 2016