16.20 - Scalar Function Support for ODBC - 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

Beginning with ODBC Driver for Teradata Release 14.10, scalar functions had to be used within escape sequences. This restriction is removed. Scalar functions can be used without escape sequences because Teradata Database natively supports them. In addition, ODBC Driver for Teradata now supports the following scalar functions:

Function Call Purpose
BIT_LENGTH(s) Returns the length in bits of the specified string.
CONCAT(s1,s2[,...sn]) Concatenates two or more parameter values into a single string.
CURDATE() Returns the current date.
CURTIME() Returns the current local time.
DAYOFMONTH(e) Returns the number of days from the beginning of the month to the specified date.
DAYOFWEEK(e) Returns the day of the week on which the specific date falls.
HOUR(e) Returns the hour field of the specified time expression.
LOCATE(s1,s2[,p]) Returns the position in s2 where the substring s1 starts.
MINUTE(e) Returns the minute field of the specified time expression.
MOD(x1, x2) Returns the remainder from a division.
MONTH(e) Returns the number of months from the beginning of the year to the specified date.
NOW() Returns the current date and time.
SECOND(e) Returns the second field of the specified time expression.
UCASE(s) Returns an equal string, which all lowercase characters convert to uppercase.
WEEK(e) Returns the number of weeks from the beginning of the year to the specified date.
YEAR(e) Returns the year of the specified date.
The following functions were updated to support ODBC Driver:
Function Call Change
CURRENT_DATE() Can be called with or without parenthesis.
LENGTH(s) Supports numeric expressions.
LTRIM(s) Operates on numeric expressions.
RTRIM(s) Operates on numeric expressions.
SUBSTRING(s,p[,n]) Returns a substring of s starting at the position p, optional length n.

Benefits

  • Customers do not have to change existing projects with scalar functions.
  • Teradata supports existing scalar functions across all Teradata products and platforms.

Additional Information

For more information, see Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates, B035-1145.