Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 14:06:39 GMT


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


Subj:   Re: Casting Time stamp in Mload
 
From:   Altaf, Muhammad

You mentioned that there is milli second part as well. You have to take that into consideration as well.

you need some thing like

     cast(:DTTM as timestamp(2) format 'yyyymmddhhmiss.s(2)')

.s(2) means that the data will have upto two milli second values. that is the data might appear like 20060131120159.12.

The length of time stamp and this milli second part is interlink and should be chosen according to the data in your file.


Regards,

Muhammad Altaf



     
  <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