Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Jan 2007 @ 19:18:34 GMT


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


Subj:   Re: Casting integer as Time
 
From:   Srinivas_Vundi

This depends on the way we want to insert integer value to Time datatype. For example if you want to insert an integer value to Time Data type as time in hours ex: 01:00:00(1 hour and zero minutes and zero seconds) then convert the SOURCE_FIELD and insert as follows

     (SOUCE_FIELD (FORMAT '99')(CHAR(02)))||':00:00'

Thanks

SRINIVAS VUNDI



     
  <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: 27 Dec 2016