Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Mar 2010 @ 15:17:45 GMT


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


Subj:   NUMTODSINTERVAL in Teradata
 
From:   Ahmad, Syed

HELLO,

I have come across one function NUMTODSINTERVAL in oracle. Here is the result for it. Does anyone know something similar in Teradata? If not then what should be the approach.

Any help would be appreciated.

     1* select numtodsinterval (150, 'second') from dual
     SQL> /

     NUMTODSINTERVAL(150,'SECOND')
     --------------------------------------------------------
     +000000000 00:02:30.000000000


     NUMTODSINTERVAL(155,'HOUR')
     -----------------------------------
     +000000006 11:00:00.000000000

Thanks,

Syed



     
  <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