Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 19 May 2004 @ 04:23:03 GMT

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

Subj:   Re: Rounding vs truncation
From:   Sanjaya Nagabhushan


DBSControl "General Fields" group has this field - RoundHalfwayMagUp. By default this is FALSE, Set this to TRUE & it will do the rounding as per your requirement. Note that this change requires a Teradata restart.



  20. RoundHalfwayMagUp - This field indicates how rounding should be performed when computing values of DECIMAL type. If this field is FALSE, the system uses the rounding semantics traditional for Teradata, namely, a value exactly halfway between representable decimal values is rounded up or down so that the least significant digit is even. If TRUE, the system uses rounding semantics appropriate for many business applications, namely, the magnititudes of halfway values are rounded up. Put differently, halfway values are rounded away from zero, so that positive halfway values are rounded up and negative halfway values are rounded down (toward negative infinity).  

  <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: 23 Jun 2019