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 |