Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 16 May 2002 @ 15:54:58 GMT


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


Subj:   Rounding in Teradata
 
From:   Matt Lipke

Why does Teradata round numbers the way it does? Is there a "real world" application of this type of rounding?

For those that are confused by this line of questioning, I am trying to round decimal fields from hundredths to tenths and for the odd tenths place values they are rounding up and the even tenths place values are rounding down. For example, .15 rounds to .2, .25 rounds to .2, .35 rounds to .4, .45 rounds to .4, etc.

And, what is the SQL to round a .15 to .2 and a .25 to .3?

Thank you for any information you can provide.

FYI, we are running Teradata V2R4.1

Matthew Lipke



     
  <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