Archives of the TeradataForum

Message Posted: Thu, 07 Oct 2004 @ 08:30:45 GMT

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

<-- Anonymously Posted: Tuesday, October 05, 2004 19:22 -->

Has anyone run across this and does anyone know why this is happening?

Basic Information:

     Running V2R5
     Teradata Admin Version 6.1.0
     BTEQWin   Teradata BTEQ 08.02.01.00 for WIN32.

I ran the following create table script in BTEQWin and in the query editor of Teradata Admin (using the same user id) and I get 2 different results as the date format. Why are the date formats different?

     CREATE TABLE Test
          ,NO FALLBACK
          ,NO BEFORE JOURNAL
          ,NO AFTER JOURNAL
      (
            Col1        INTEGER NOT NULL,
            Col2          INTEGER NOT NULL,
            Col_DT DATE NOT NULL,
            Col_TM TIME(0),
     );

I then look in Teradata Admin (show definition for each table)

The one ran in BTEQ display as:

     CREATE SET TABLE TestInBTEQ ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           Col1 INTEGER NOT NULL,
           Col2 INTEGER NOT NULL,
           Col_DT DATE FORMAT 'DD-MMM-YYYY' NOT NULL,
           Col_TM TIME(0))
     PRIMARY INDEX ( Col1 );

The one ran in Teradata Admin displays as:

     CREATE SET TABLE Test ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL
          (
           Col1 INTEGER NOT NULL,
           Col2 INTEGER NOT NULL,
           Col_DT DATE FORMAT 'yyyy-mm-dd' NOT NULL,
           Col_TM TIME(0))
     PRIMARY INDEX ( Col1 );

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