Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 01 May 2006 @ 16:47:53 GMT





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




Subj:   Re: Problem with type casting Timestamp
 
From:   Victor Sokovin



  In Fexport script I type casted COL1TIMESTAMP as cast (COL1TIMESTAMP as varchar(20)) and The second column also same as well that is cast (COL2DATETIME as varchar(20)).  


Try to cast to VARCHAR(22). I think the problem might be caused by the fractional seconds precision.


Regards,

Victor





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008