Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Jul 2001 @ 13:23:53 GMT


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


Subj:   Current_timestamp Question
 
From:   Tony Howe

When INSERTing a CURRENT_TIMESTAMP into a column mark defined as TIMESTAMP(6), it appears to not utilize the complete microseconds, last 6 positions, to it's fullest potential. In other words it will insert 130000 instead of 138372 in the last 6 positions. Anyway to get this to utilize all 6 positions. How does Teradata come up with the microseconds??

Thanks, Tony.



     
  <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