 |
 |
Archives of the TeradataForum
Message Posted: Wed, 03 Jan 2007 @ 17:35:06 GMT
| Subj: | | Re: Casting integer as Time |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, January 03, 2007 11:05 -->
Someone wrote:
| | Please note TIME(0) will be treated as integer in ANSI mode not in TERADATA mode. | |
No. But it IS true that if you "enable parsing" or "allow use of ODBC extensions", the ODBC driver may quietly change your CREATE TABLE
statements before submitting them to the DBMS. That includes changes based on DateTimeFormat settings when in TERADATA session mode - and the
default DateTimeFormat is III for Teradata-specific backward-compatible INTEGER/FLOAT versus AAA for native data types compatible with ANSI.
| |
