16.10 - RoundHalfwayMagUp - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Determines how rounding is performed when computing values of DECIMAL type. A halfway value is exactly halfway between representable decimal values.

Field Group

General

Valid Settings

The rounding behavior is different depending upon the setting of the RoundHalfwayMagUp field.

IF you set the field to… THEN the Teradata Database system uses the rounding semantics…
TRUE appropriate for many business applications:

The magnitudes of halfway values are rounded up. 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). For example, a value of 2.5 is rounded to 3.

FALSE traditional for Teradata Database:

A halfway value is rounded up or down so that the least significant digit is even. For example, a value of 2.5 is rounded to 2.

Default

FALSE

Changes Take Effect

After the next Teradata Database restart.