Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 28 Mar 2003 @ 15:26:20 GMT

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

Subj:   Re: Timestamp difference
From:   Fred W Pluebell

An addendum to Ian Russell's comments regarding ODBC DateTimeFormat. These settings are only effective at session logon; if you're already logged on, you'll need to log off and log on again to see the difference.

As Ian noted, an "I" in one of the positions (for Date, Time, Timestamp, respectively) causes the driver to quietly modify certain SQL elements dealing with the corresponding ANSI datatype, in an attempt to provide backward compatibility with V2R2 and earlier. An "A" causes those elements to be passed as written.

  <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: 27 Dec 2016