Archives of the TeradataForum

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

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

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>>