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 .