Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2006 @ 14:38:17 GMT

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

Subj:   Re: Casting Time stamp in Mload
From:   Victor Sokovin

  We are having Data in flat file structure extracted thru COBOL program & timestamp using systemtime in unix that is YYYYMMDDHHMMSSMS, now we want to load the same in Teradata database as timestamp. Please advice how to cast the said field in MLoad script.  

I think the problem is in the final CAST. It relies on the session defaults. The default in the SQLA session is probably in line with the data, and everything works. But the ML session might have different defaults. In general, it is probably not a good idea to rely on session defaults. Try to CAST to TIMESTAMP(0)using the explicit FORMAT, in the similar way as you CAST to DATE in the above SQL.



  <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