16.10 - BITAND, GREATEST/LEAST, and TRUNC/ROUND Enhancements - Teradata Database

Teradata Database Release Summary

Teradata Database
June 2017
Release Notes
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┬« Database SQL Functions, Operators, Expressions, and Predicates, B035-1145.
  • For more information about the TruncRoundReturnTimestamp DBS Control field, see Teradata┬« Database Utilities , B035-1102 .