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'



  <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