Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Jan 2007 @ 17:35:06 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020