Archives of the TeradataForum

Message Posted: Mon, 12 Nov 2007 @ 22:42:43 GMT

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

I see that the text of my casting expression got garbled. Ignore the asterisks; it should have read:

     cast(cast(cast(DT_TM_NUM MOD 1000000 as format '99:99:99') as char(8)) as time(0))

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