Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Sep 2003 @ 03:11:31 GMT


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


Subj:   Re: Round 5 up (override "RoundHalfwayMagUp" set to FALSE)
 
From:   Michael Larkins

One of the things that seems to help solve this issue is to add a decimal number that is so small that it would never change the actual data (like .00000000000000000000001) but it does cause the value to be more than .5 (half way) and thus rounds up.

Hope this helps give you an idea of a way around the flag setting.


Regards,

Michael Larkins
Certified Teradata Master



     
  <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