This section describes how the entry level ANSI SQL 1992 syntax is supported by ODBC Driver for Teradata, including DATE and TIME literals and the functions listed.
Syntax | Notes |
---|---|
EXTRACT() | None |
TRIM() | Remove only spaces and 0s The ANSI syntax for TRIM is very different from ODBC syntax for Teradata syntax. Migration: The TRIM function works differently in Teradata and ANSI modes. In Teradata mode, TRIM only removes trailing blanks. In ANSI, TRIM removes leading as well as trailing blanks. |
SUBSTRING() | The ANSI syntax for SUBSTRING is very different from ODBC syntax for Teradata syntax |
CAST() | None |