The following transformations of standard Teradata types are deprecated as of 16.20.
| Teradata Data Type | Legacy Transformation by Teradata ODBC |
|---|---|
| BIGINT |
When used with early databases that did not support BIGINT, ODBC Driver for Teradata would map BIGINT to DECIMAL(18,0). All database versions currently supported by ODBC Driver for Teradata have a Native BIGINT type and this mapping is obsolete. |
| DATE |
ANSI Date mode is the default and is what an application should use. In Integer Date mode, the DATE type, when used in a column definition or type cast will be replaced by: DATE FORMAT 'YYYY-MM-DD' The replacement occurs only if no FORMAT phrase has explicitly been used. The Integer Date mode is supported by the database and the default database format is ‘YY/MM/DD’, which is different from the standard ODBC and ANSI format. An application that uses Integer Date mode and relies on ODBC to set the date FORMAT in the SQL text previously could use the EnableLegacyParser option, but this has been removed. Your application needs to use ANSI Date mode (preferred default) or set explicit FORMATs. |
| TIME[(n)] |
If Integer Time mode is used then the TIME type when used in a column definition or type cast will be replaced by: INTEGER FORMAT '99:99:99' Any precision is ignored. The Integer Time mode is an ODBC TIME type implementation for database versions not supporting true ANSI TIME types. Integer Time mode is deprecated in ODBC 15.00 and is not recommended for use. |