Archives of the TeradataForum

Message Posted: Fri, 05 Jan 2007 @ 11:56:49 GMT

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

Victor Sokovin wrote:

     > sel substring(73000  (format '999999') (char(6)) from 1 for 2) || ':' ||
     > substring(73000  (format '999999') (char(6)) from 3 for 2) || ':' ||
     > substring(73000  (format '999999') (char(6)) from 5 for 2)
     > Event_Start_Tm

No need for substrings :-)

     select 73000  (FORMAT '99:99:99') (CHAR(8))

Dieter

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