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??


  <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: 15 Jun 2023