Archives of the TeradataForum

Message Posted: Wed, 09 Jan 2008 @ 16:30:02 GMT

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

You can accomplish this via a double cast

     SELECT CAST(CAST(DATE AS DATE FORMAT 'YYMM') AS CHAR(4));

Hope this helps.

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