Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Apr 2007 @ 15:39:10 GMT


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


Subj:   Re: BigINT and Timestamp
 
From:   Geoffrey Rommel

  With the coming of BIGINT (8 byte integer), is NCR planning to convert timestamps to BigINT rather than continue to use the embedded space (between the date and time) approach it uses today?  


I haven't heard anyone from Teradata address this question, but I'm sure the answer is no. Timestamps are stored internally as a structure of 10 bytes. All the components are binary numbers; there are no characters or spaces. The character string with space ('yyyy-mm-dd hh:mi:ss...') is an ANSI standard for the external representation of the data. In other words, this format is used only when importing or exporting timestamps; it is not used internally.

I'm not sure how you are envisioning using bigints, but if for instance you wanted to store a timestamp as the number of microseconds since 1970-01-01 00:00:00.00, you would have to perform this conversion yourself.



     
  <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