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 Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008