Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 13:18:26 GMT

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

Hi John,

Could you please try this ..

     Sel cast (cast(cast (Crdtd_Dt as date) as date format 'yyyymmdd') as char(8));

Regards,

A.Navin

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