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

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K
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.

Benefits

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

Considerations

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 .