Archives of the TeradataForum

Message Posted: Wed, 13 Sep 2006 @ 17:28:43 GMT

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

Try this one:

     select cast(cast(date as integer) + 19000000 as char(8));

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