ANSI SQL 1992 Syntax - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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