Archives of the TeradataForum

Message Posted: Wed, 19 Jul 2006 @ 13:00:11 GMT

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

Hi Vinod,

Use this in SQL Assistant, you will see the result as expected.

     select substr(CAST(calendar_date AS format 'mmmYY' ) ,1,6) x from
     sys_calendar.calendar sample 2;

Regards

Rashid Ahmed Khan
DBS Bank - SG

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