16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

ROUND functions as follows:

  • It rounds places_value places to the right of the decimal point if places_value is positive.
  • It rounds places_value places to the left of the decimal point if places_value is negative.
  • It rounds to 0 places if places_value is zero or is omitted.
  • If numeric_value or places_value is NULL, the function returns NULL.
  • ROUND rounds the value away from zero and it only rounds when the next digit is a value of 5 or greater.
The rounding behavior always follows the above formula regardless of the setting of the DBS Control Record RoundHalfWayMagUp field. That is, the rounding behavior always functions as if the RoundHalfWayMagUp field is set to TRUE.