Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Nov 2006 @ 20:40:07 GMT


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


Subj:   Length of timestamp
 
From:   Simard Rudel

Hi all,

We tried to use the TIMESTAMP(6) for data type in a table, in the documentation it's say than the length of the internal stored form is 10 bytes for a timestamp data type. Surprise, the length we see in DBC.COLUMNS views for our table is 26 bytes. If I looked for all DBC tables how their timestamp as been defined, they are fine with 10 bytes.

The way we define the table is :

     CREATE SET TABLE DATA_BASE.TTABLE_NAME ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
     TOC_TOC_TOC INTEGER,
     DHC_OCC_DP_ACTE_MD TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6))
     PRIMARY INDEX ( TOC_TOC_TOC );

Is their a system variable to set?

RS



     
  <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