Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Nov 2005 @ 17:54:19 GMT


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


Subj:   Re: Intelligent rounding off
 
From:   Micheletto, David

Yes.

There are two methods for rounding and the method is set in a DBSControl field (General field). The method you have is to round to the even number when digit to the right equals 5. This prevents the bias towards rounding up.

It (the DBSControl field) can be set to round so that if the digit to the right is 5 or more (>4) round up else round down (leave the same). (biased towards rounding up)


David L. Micheletto
Senior Instructor
Teradata Certified Master
Teradata, a division of NCR



     
  <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: 15 Jun 2023