Archives of the TeradataForum

Message Posted: Tue, 15 Sep 2009 @ 15:10:17 GMT

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

Hi,

to understand the TD behavior run the query :

     sel format(cl1) from my_tab;

You will see the default format -(10)9, which contains 11 chars. After casting to varchar(10) last char is cut.

regards

Marek

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