Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 01 Dec 2006 @ 11:09:13 GMT


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


Subj:   Re: Length of timestamp
 
From:   Dieter Noeth

Anomy.Anom wrote:

  I'm not sure if I did something incorrectly in the BTEQ above or am misreading the doc but can anyone help me confirm this?  


OK, there's another manual ;-)

     SQL Reference: Data Types and Literals
     Chapter 4: DateTime and Interval Data Types
     TIMESTAMP Data Type

Internal Representation of TIMESTAMP

...
Conceptually, TIMESTAMP is treated as a record composed of six fields, defined appropriately for the Gregorian calendar.

...
The length of the internal stored form is 10 bytes.

...
External Representation of TIMESTAMP
TIMESTAMP types are imported and exported in record and indicator modes as CHARACTER data using the ANSI format string


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