Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 23 Feb 2007 @ 10:14:47 GMT


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


Subj:   Re: Alter Table from Datype date to timestamp
 
From:   D silva, Joseph Vinish

You might also find it be a bit faster if you create a new table from the old table with conversion applied on the "date" column and then drop the old table and rename the new table. That would avoid all the transient journal trouble.


Joseph D'silva



     
  <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: 28 Jun 2020