defaultRoundingMode property

String? defaultRoundingMode
getter/setter pair

Defines the default rounding mode specification of new decimal fields (NUMERIC OR BIGNUMERIC) in the table.

During table creation or update, if a decimal field is added to this table without an explicit rounding mode specified, then the field inherits the table default rounding mode. Changing this field doesn't affect existing fields.

Optional. Possible string values are:

  • "ROUNDING_MODE_UNSPECIFIED" : Unspecified will default to using ROUND_HALF_AWAY_FROM_ZERO.
  • "ROUND_HALF_AWAY_FROM_ZERO" : ROUND_HALF_AWAY_FROM_ZERO rounds half values away from zero when applying precision and scale upon writing of NUMERIC and BIGNUMERIC values. For Scale: 0 1.1, 1.2, 1.3, 1.4 => 1 1.5, 1.6, 1.7, 1.8, 1.9 => 2
  • "ROUND_HALF_EVEN" : ROUND_HALF_EVEN rounds half values to the nearest even value when applying precision and scale upon writing of NUMERIC and BIGNUMERIC values. For Scale: 0 1.1, 1.2, 1.3, 1.4 => 1 1.5 => 2 1.6, 1.7, 1.8, 1.9 => 2 2.5 => 2

Implementation

core.String? defaultRoundingMode;