16.20 - BITAND, GREATEST/LEAST, and TRUNC/ROUND Enhancements - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Release Notes
Publication ID
English (United States)
Last Update
This feature extends several existing functions allowing them to handle additional data types:
  • The BITAND function will accept the NUMBER data type as input and output.
  • The GREATEST and LEAST functions will accept the DATE and TIMESTAMP data types as input and output.
  • The TRUNC and ROUND functions will return a TIMESTAMP data type if you use TIMESTAMP as input.


  • Provides increased functionality for these functions.
  • Provides compatibility with other databases.


By default, if you pass a TIMESTAMP value to the TRUNC or ROUND functions as input, TRUNC or ROUND returns a DATE value. To enable TRUNC or ROUND to return a TIMESTAMP value when you pass in TIMESTAMP as input, you must set the TruncRoundReturnTimestamp DBS Control field to TRUE.

Additional Information

  • For more information about these function enhancements, see Teradata Vantage™ SQL Functions, Expressions, and Predicates, B035-1145.
  • For more information about the TruncRoundReturnTimestamp DBS Control field, see Teradata Vantage™ - Database Utilities , B035-1102 .