Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 13:45:10 GMT


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


Subj:   Re: ODBC 'datetime' format
 
From:   Geoffrey Rommel

  In the above line, What EXACTLY does 'DATE format' mean?  


It means that the default format used when returning dates will be either 'YYYY-MM-DD' (ANSI) or 'MM/DD/YY' (Integer). I believe that this default format will also be applied to date literals in your SQL, so if it's set to 'A' you should specify date literals in 'YYYY-MM- DD' form.


  And why did my queryman/command of create table with a column defined as TIME get converted to INTEGER, and TIMESTAMP to char, when the DATETIME format was set to 'I' for both?  


Not sure, but I believe this has something to do with the ODBC setup. If you are using ODBC driver 3.00, checking the option "Disable PREPARE" may solve this problem. Anyone??


--wgr



     
  <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