Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 15:30:42 GMT

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

Thanks all for your prompt responses.

The issue was with SQLA.. when I tried to run through bteq mode..the same query sel cast(cast(Crdtd_Dt as date) AS date format 'yyyymmdd') was working fine..

Thanks again.

John

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