Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 14 Apr 2013 @ 19:09:17 GMT


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


Subj:   Re: DateTimeFormat's in SQLA/TD
 
From:   Dieter Noeth

Asifuddin MD wrote:

  I am confused on the datetimeformats in SQLA which state AAA,III and so on.. Any explanation on all those please or a direct location I can refer to.  


It's not a SQLA option, it's ODBC, so you'll find the info in the ODBC manual.

It's about how DATE/TIME/TIMESTAMP datetypes are treaed by the ODBC driver. "I" means INTEGER, mainly used for compatibility with old applications (at least for TIME and TIMESTAMP), "A" means ANSI, which is preferred.

The default used to be III, but IAA or AAA is recomended.

For dates I/A is similar to SET SESSION DATEFORM = INTEGERDATE/ANSIDATE.


Dieter



     
  <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: 23 Jun 2019